Question

Is there a work instruction to sort a text file then export as a Excel? I have attached my current workbench and file as ZIP. I need to sort into 0-500, 501-2000, 2001+ sections.

  • 16 March 2022
  • 1 reply
  • 0 views

Is there a work instruction to sort a text file then export as a Excel? I have attached my current workbench and file as ZIP. I need to sort into 0-500, 501-2000, 2001+ sections.

1 reply

It will help you a lot if you read that file as CSV, rather than Text file, since your file is structured that way (Comma Separated). Make sure that you specify Field Names = 0 (for data without header).

 

You can also specify which columns are containing geometry information (lat, lon).

 

image 

Reply