View Single Post
  #1   Report Post  
kima kima is offline
Junior Member
 
Posts: 9
Default SOLVED importing cvs file!!

I get some number from a measuring station i a cvs file. But they have made a programming fault making some of the negative results arriving with "--" instead of "-"

example:

-3.543
0.392
--2.274

This gives problems importing. Resulting in:

-3,543
0,392
2,274

Any ideas how to solve this!!

Have attached the cvs file!!

SOLVED IT … had to import cvs to A:A (TEXT) then Replace "--" with "-" and then use text to columns.
Attached Files
File Type: zip 205FDB_PROFILE1_20121102060003_003.CSV.zip (16.9 KB, 32 views)

Last edited by kima : November 5th 12 at 12:37 AM