3 ms·
>sep=; Thank you! This is a game changer. As I was reading through these comments I was thinking how much better it would be if the separator could be specifie
by al_borland 3y ago
>sep=;
Thank you! This is a game changer. As I was reading through these comments I was thinking how much better it would be if the separator could be specified in the file, but it would only be useful for my own stuff, if I was to do that on my own.
I’ll be trying this first thing tomorrow at work. I don’t do as much with CSVs as I used to, but am currently working with them a lot, and have a single entry that always throws the resulting Excel file off, and I can’t be bothered to figure out how to escape it (I spent too much time in the past messing with that and got nowhere). This sep= lines will hopefully solve my issues.
- heresie-dabord 3y agoI have sometimes distributed a CSV file with a similarly-named text file that contains key-value pairs to aid in the use of the CSV file. A minimal text file of this type would contain: #key=value sep=;