CSVfox
Leverage Your Data.
 English

±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.

The default delimiter (field separator) depends on the local windows installation locale, if there is no deviating information or %locale setting.
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;sledge
outfile.csv:
Spring|Summer|Autumn|Winter blossoms|"green leaves"|"fruits and nuts"|"tiles stove" bicycle|cabrio|pick-up|sledge
Under construction, coming soon