<< Click to Display Table of Contents >> Navigation: Reference > File formats > CSV format |
Easy Data Transform can input from and output to CSV format files. File extension ".csv".
CSV (Comma Separated Value) format is commonly used for exchanging tabular data between programs.
CSV is a type of delimited text file format. Carriage return denotes the end of a row. The column delimiter is usually commas, but not always.
Easy Data Transform supports the following column delimiters:
•comma (,)
•semi-colon (;)
•pipe (|)
•caret (^)
For all the above delimiters:
•If a value field contains a delimiter character, then the value will be surrounded by quotes (").
•If a value field contains a quote (") character, then the quote will be 'escaped' by an additional quote.
For example:
Is output as:
CategoryID,CategoryName,Description,In stock
1,Beverages,"Soft drinks, coffees & teas",true
2,Condiments,Sweet and savory sauces,false
3,Confections,Candies and sweet breads,true
Tab delimited (TSV) files are treated a bit differently.