Re: Semicolon delimited to Comma delimited

[Tux]

Disregarding the Microsoft issues with localized list-separator characters, as described here, and given that you already have exported to CSV, be it with another separator than the required ,, the solution is extremely simple, using Text::CSV_XS:

$ cat bad.csv
a;b;c
1;2;3
;4;
"Føó";"Hēłŀõ Ẇőŕļđ";
$ perl -C3 -MText::CSV_XS=csv -we'csv (in => "bad.csv", sep => ";")'
a,b,c
1,2,3
,4,
Føó,"Hēłŀõ Ẇőŕļđ",

[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.