Trouble importing points

[Charles Owens]

Something odd about the bad file. If you do a find(, ) and replace(,) using notepad the program does not find anything to replace. But the comma and space are there. Another flipping AutoCad issue to mess with.]

 

[Matt Johnson]

I checked in Notepad++. NUL characters are being inserted.

@Mikhail Drakin can probably implement a fix to ignore the NUL characters.

 

[Charles Owens]

Something odd about the bad CSV file. If you do a find(, ) and replace(,) using notepad or wordpad or SMI Transfer it does not find the space. It is not there.

 

[Matt Johnson]

Notepad++ can me used to fix it.

 

[Jim Frame]

The import function is kind of brain-dead if it can't remove non-numeric characters in front of the coordinate values.

 

[Mikhail Drakin]

NUL symbol after a separator is definitely the problem of generator software. I'll see what can be done, though I for one do not see any reason to support ill-formed files. The obvious consequence of "removing non-numeric characters in front of coordinate values" (I suppose you call N,S,W and E also non-numeric? But we read and treat them as well) will be breaking of code, name and description handling. Currently you see the problem immediately and fix it at the source. If I hide it, you'll end with random garbage in text fields (obviously, NUL is just a random symbol in this case, there could be any other in it's place, including any random digit).

 

[Jim Frame]

You're right, I hadn't considered geographic coordinates, I was thinking only of PNEED files, which is what I deal with in my own software. I do remove whitespace characters in those when reading/writing, though.

 

[Mikhail Drakin]

Note that NUL is not a whitespace character and always requires special handling. And it should not be met in a text file at all.

 

[Mikhail Drakin]

Starting from one of the next builds, NUL in CSV will be completely ignored. Please note that appearance of a NUL in a text file generally means that any random symbol may appear in its place next time, so it is better to find and eliminate the reason why it gets there.