CSV files use delimiters other than commas

From Data-gov Wiki

Jump to: navigation, search
Infobox (Issue Report) edit with form
  • name: CSV files use delimiters other than commas

Current Issues in data.gov



Description

"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:

  • Tabs
  • 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.).

Examples

~0100~^~Dairy and Egg Products~
~0200~^~Spices and Herbs~
...

Related Tags

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

Facts about CSV files use delimiters other than commasRDF feed
Dcterms:created25 June 2010  +
Dcterms:creatorSarah Magidson  +
Dcterms:modified2010-6-28
Foaf:nameCSV files use delimiters other than commas
Related tagTab-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:altLabelCSV files use delimiters other than commas  +, csv files use delimiters other than commas  +, and CSV FILES USE DELIMITERS OTHER THAN COMMAS  +
Personal tools
internal pages