5
1
I usually put "sep=," or "sep=;" as first line on my csv files so i can easily open them with excel. But is there a way to use this with space and tab separated files?
Madmenyo
Posted 2013-09-20T08:56:45.563
Reputation: 800
Space or tabs as separator in CSV
Answers
8
"sep=/t" for tab delimited
"sep= " for space delimited, should work
Raystafarian
Posted 2013-09-20T08:56:45.563
Reputation: 20 384
Is it a part of CSV standard or custom Excel thing? – Bogdan Gusiev – 2015-07-28T16:02:00.550
@BogdanGusiev I'm pretty sure this is part of the way excel processes csv files, but I've never found any documentation on it. see here
– Raystafarian – 2015-07-28T16:04:30.200I actually never used ", so this did not seem to work for the space issue until i literally typed the quotes. – Madmenyo – 2013-09-20T10:35:53.023