Questions tagged [delimited-files]
3 questions
16
votes
7 answers
Best way to handle delimited files
So typically a CSV file uses a comma and the return character as it's field and line delimiters.
This runs into obvious problems with text which can contain both these characters.
Obviously there are options there (escaping them) but how do people…

Jon Hopkins
- 22,734
- 11
- 90
- 137
5
votes
5 answers
How are new file formats constructed?
I've used a software suite that is installed in offices and on remote vessels. The installations communicate back and forth, and they do that by using a simple proprietary file format that looks something like…

Danny Beckett
- 153
- 7
4
votes
5 answers
What would happen if you defined your system's CSV delimiter as being a quotation mark?
Title says it all. If the CSV's system delimiter was " (as opposed to a comma or pipe or other common alternatives), how would anything deal with it?
The crux of the matter is of course that by definition, CSV will surround any values containing the…

Alain
- 335
- 2
- 13