This is a common file format for simple spreadsheet and database transfer between applications.
A CSV file consists of numbers and textual labels, with fields separated by commas and records by a line separator.
The following demonstrate most of the characteristics of the CSV file format:
123.456, |
7.8E9, |
"textstring1", |
"text""string2", |
"text,string3" |
" text string 4 " |
1 | 2 | 3 | 4 | 5 | 6 |
E
and lower-case e
being acceptable.text"string2
.
White space (spaces or TAB characters) on either side of comma separators is ignored.
White space within numbers is erroneous.
PipeDream treats any of these single characters or character pairs:
LF
CR
CR,LF
LF,CR
as line separators.