CSV files use delimiters other than commas
From Data-gov Wiki
"CSV" stands for "comma-separated values", though many datasets use a delimiter other than a comma. This is not a major hurdle, as most programs that handle CSV can handle different delimiters, but it does make the parsing process just a little harder.
Delimiters (other than commas) that we have seen include:
- Semi-colons (;)
- Pipes (|)
- Carets (^)
There is also one instance where tildes (~) are used where quotes would conventionally be used in CSV, i.e. to bracket a field and escape the delimiters inside it ("value1, is number one", "value2, really the second one", etc.).
- Dataset 994 (datafile) uses tabs to delimit fields instead of commas.
- Dataset 1359 (datafile) uses pipes to delimit fields, but otherwise follows conventional CSV format.
- Datasets 1362 through 1372 use semi-colons as delimiters.
- Dataset 1458 (ZIP file with data) uses carets for delimiters. Also worth noting is that tildes are used in place of quotes, so the data looks like
~0100~^~Dairy and Egg Products~ ~0200~^~Spices and Herbs~ ...
SMWiki: Category:Tab-delimited csv
Google Spreadsheet: tab-delimited, semi-colon-delimited, pipe-delimited, ^-delimited (under layout) - Category:Datafile layout tab-delimited, Category:Datafile layout semi-colon-delimited, Category:Datafile layout pipe-delimited, Category:Datafile layout caret-delimited, Category:Datafile layout tilde-quoted
|Dcterms:created||25 June 2010 +|
|Dcterms:creator||Sarah Magidson +|
|Foaf:name||CSV files use delimiters other than commas|
|Related tag||Tab-delimited csv +, Datafile layout tab-delimited +, Datafile layout semi-colon-delimited +, Datafile layout pipe-delimited +, Datafile layout caret-delimited +, and Datafile layout tilde-quoted +|
|Skos:altLabel||CSV files use delimiters other than commas +, csv files use delimiters other than commas +, and CSV FILES USE DELIMITERS OTHER THAN COMMAS +|