Borehole number orders when exporting as excel file

Hi everyone,

I have a set of boreholes logged with numbers varying between BH20-01 to BH20-301. My issue is that when I am exporting my gINT file in excel format, the gINT changes the order of the boreholes in tables. For example, BH20-112 shows up above BH20-23. Even BH20-204 shows up above BH20-25 and et cetera ,since the software doesn't recognize the numbers in whole and treats each figure separately. Is there any fix to this? Would appreciate any help. 

Thanks,

Faraz

Parents
  • Many people pad their alpha numeric boring numbers with zeros for just this reason. Borings TB-001, TB-002, TB-003, TB-013, TB-123 will sort in the expected order.  Borings TB-1, TB-2, TB-3, TB-13, TB-123 will sort TB-1, TB-123, TB-13, TB-2, T-3.  If you don't want to change your boring numbers you can add a field to your export of the point table named SortOrder (or something else of your choosing so long as it is a valid field name).  In the correspondence file for the export you would include an expression for this field similar to <<RightNum(<<Point.PointID>>)>>. (your expression may be different based on your actual table names and data structure).  This will create a column in excel that just has the numeric portion of the boring number without the text prefix.  You can then sort on this column in excel to get the expected order.

Reply
  • Many people pad their alpha numeric boring numbers with zeros for just this reason. Borings TB-001, TB-002, TB-003, TB-013, TB-123 will sort in the expected order.  Borings TB-1, TB-2, TB-3, TB-13, TB-123 will sort TB-1, TB-123, TB-13, TB-2, T-3.  If you don't want to change your boring numbers you can add a field to your export of the point table named SortOrder (or something else of your choosing so long as it is a valid field name).  In the correspondence file for the export you would include an expression for this field similar to <<RightNum(<<Point.PointID>>)>>. (your expression may be different based on your actual table names and data structure).  This will create a column in excel that just has the numeric portion of the boring number without the text prefix.  You can then sort on this column in excel to get the expected order.

Children