Titel

Old		New
1		1	Csv Formats

Permalink

Old		New
1		1	csv_formats

Inhoud

Old		New
		1	# CSV Formats
1		2
		3	LiteCart tries to support the most common variations of non-standard CSV
		4	formats but one is prefered.
		5
		6	\^ Format \^ Delimiter \^ Column Wrapper \^ Escape character \^ Encoding
		7	\^ EOL | CSV | , | " | " | UTF-8 w/o BOM | CR+LF
		8
		9	A list of CSV formats supported by applications.
		10
		11	\^ Application \^ Format \^ Delimiter \^ Column Wrapper \^ Escape
		12	character \^ Encoding \^ EOL \^ Recommended \^ Comments | Google Docs
		13	Spreadsheet (Web application) | CSV / TSV | , or TAB | " | " |
		14	Any | CR / LF / CR+LF | **Yes** | | Microsoft Office Excel 2010
		15	(numerals with decimal point) | CSV (MS-Dos) | , | " | " | UTF-8
		16	w/o BOM | CR+LF | No | Excel 2011/Mac cannot correctly interpret a
		17	CSV file containing umlauts and diacritical marks no matter what
		18	encoding. | Microsoft Office Excel 2010 (numerals with decimal comma)
		19	| DSV (MS-Dos) | ; | " | " | UTF-8 w/o BOM | CR+LF | No |
		20	Excel 2011/Mac cannot correctly interpret a CSV file containing umlauts
		21	and diacritical marks no matter what encoding. | Microsoft Office Excel
		22	2011 (numerals with decimal point) | DSV (Mac) | , | " | " |
		23	Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of
		24	Excel will not be able to deal with Unicode in CSV. | Microsoft Office
		25	Excel 2011 (numerals with decimal comma) | CSV (Mac) | ; | " | "
		26	| Windows-1252, UTF-8 w/ BOM | CR | No | Many regional versions of
		27	Excel will not be able to deal with Unicode in CSV. | LibreOffice Calc
		28	(Multi platform) | CSV / DSV / TSV | Any | " or ' | " | Any |
		29	CR / LF / CR+LF | **Yes** | Supports all variations
		30
		31	w/ BOM = With Byte Order Mark
		32
		33	w/o BOM = Without Byte Order Mark

Geredigeer deur litecart op 29 Des. 2023 om 04:28