CSV Encoding

When downloading data in CSV format, there are some values that need to be quoted. Extole uses the following algorithm for determining which values to quote:

If the value contains a comma or any ASCII character lower than a comma - this includes a space and ,!"#$%&'()*+
If the value is longer than 24 characters

Here are some examples:

Value in CSV File	Reason for Quoting
[email protected]	None
"[email protected]"	Over 24 characters
"coupon1,coupon2"	Comma in value
"United States"	Space in value
refer-a-friend	None
"[email protected]"	Plus in value

For more information on SFTP and file transfers, see: https://success.extole.com/hc/en-us/articles/201898316-SFTP-and-Batch-File-Conventions.