Re^2: Semicolon delimited to Comma delimited

[swatzz]

Sorry forgot to point out or rather make clear that i am extracting data from *.csv and writing to Excel. And there is this one sheet in Excel which completely copy pastes the contents of *.csv file to Excel. I just call it 'raw data'. This part does not work at all with my Indian counterpart because of this weird 'semi-colon - comma' issue :(

[marinersk]

Interesting; I'd missed this when I first read the thread.. I've found CSV to be unreliable as a copy/paste source, and generally use TSV which is astoundingly reliable in Excel.

Doesn't solve your problem, of course; you still need to know which semicolons to convert to tabs or commas and so this hasn't helped you at all -- just a note from a fairly heavy Excel user, in case it helps you in the future.