in reply to Semicolon delimited to Comma delimited
Add a line with sep=; at the top of the csv file. Excel will read this as an instruction and override the end user's default separator. This should still be readable on your end as well but it's quite possibly specific to Excel.
Minor point but the semicolon variant isn't used everywhere in Europe but I did see it when working with a German company.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Semicolon delimited to Comma delimited
by Tux (Canon) on Apr 24, 2015 at 14:34 UTC | |
by igelkott (Priest) on Apr 24, 2015 at 16:24 UTC | |
by Tux (Canon) on Apr 24, 2015 at 16:37 UTC | |
by marinersk (Priest) on Apr 24, 2015 at 16:17 UTC | |
by Anonymous Monk on Apr 24, 2015 at 21:13 UTC | |
Re^2: Semicolon delimited to Comma delimited
by marinersk (Priest) on Apr 24, 2015 at 00:42 UTC |
In Section
Seekers of Perl Wisdom