I need to import .csv files into excel. Problem is that the program
that exports the .csv files comma sepatates the values and the values
themselves contain commas. For example:
3,14,-1,28,0,74
Should be interpreted as:
3,14 -1,28 0,74
The only thing I have going for me is that all the values contain
commas. This means I should be able to replace every second comma with
another delimiter and thus be able to read the file correctly.
Something like this:
3,14;-1,28;0,74
I“ve been thinking about how to go about this but haven“t been able to
come up with anything that works. Does anyone have any suggestions on
how to replace every second comma in a string?
Regards / Thomas L
Bookmarks