Skip to main content
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.

  • March 16, 2022
  • 1 reply
  • 5 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

hrvoje
Participant
Forum|alt.badge.img
  • Participant
  • March 16, 2022

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 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings