±delimiter, ±d
Delimiter setting of the input or output CSV file
Description
Sets the assumed field delimiter for reading a CSV file.
Sets the field delimiter for writing a CSV file.
In most countries, where the decimal separator is a dot (.), the standard CSV delimiter is the comma (,).
However, where the decimal separator is a comma (like in germany) the CSV field delimiter is very often a semicolon (;) instead.
Pattern
±d=delimiter
±delimiter=delimiter
Usage Examples
- csvfox infile.csv +d=";" (...)
- Assumes that the CSV file to read has semicolon as field delimiter.
- csvfox infile.csv -d=pipe outfile.csv
- Reads infile.csv (with local default delimiter) and writes it into outfile.csv, using a pipe ("|") character as field delimiter for writing.
- csvfox infile.csv +d=";" -d=pipe outfile.csv
- Reads infile.csv with given field delimiter ";", and writes it into outfile.csv, using a pipe ("|") character as field delimiter for writing.
infile.csv:Spring;Summer;Autumn;Winter blossoms;"green leaves";"fruits and nuts";"tiles stove" bicycle;cabrio;pick-up;sledgeoutfile.csv:Spring|Summer|Autumn|Winter blossoms|"green leaves"|"fruits and nuts"|"tiles stove" bicycle|cabrio|pick-up|sledge