Re^2: Semicolon delimited to Comma delimited

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 :(

Comment on Re^2: Semicolon delimited to Comma delimited

Replies are listed 'Best First'.
Re^3: Semicolon delimited to Comma delimited by marinersk (Priest) on Apr 24, 2015 at 00:40 UTC
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.	[reply]

Replies are listed 'Best First'.

Re^3: Semicolon delimited to Comma delimited
by marinersk (Priest) on Apr 24, 2015 at 00:40 UTC

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.

[reply]