Emu48 Edit a CSV File

[DavidM]

(01-08-2022 07:41 PM)MNH Wrote:  Please note that all substrings will not be of equal lengths, because some coordinate pairs will have point numbers containing 1 to 5 digits. Also, an actual coordinate file will be in the form of P,N,E,Z,D (e.g., 208,1531217.411,520676.455,98.393,IRC 1/2 LB 6300) where:

P is the point number
N is the northing
E is the easting
Z is the elevation
D is the description

Does your final list need to have all of the fields present? Or just some?

One possible way to do this would be to convert every field to a string in a first pass, then extract only the needed fields while converting to numeric objects. It would be easier to show with some real data.

Would you be able to post a complete example of the "FILE" string that contains real data for experimentation?