Re: Semicolon delimited to Comma delimited

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ēłŀõ Ẇőŕļđ",

Enjoy, Have FUN! H.Merijn

Comment on Re: Semicolon delimited to Comma delimited Download Code

Replies are listed 'Best First'.
Re^2: Semicolon delimited to Comma delimited by swatzz (Novice) on Apr 23, 2015 at 14:00 UTC
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 :(	[reply]
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]