View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Triple7 Triple7 is offline
external usenet poster
 
Posts: 2
Default Removing every second instance of comma sign

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