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://docs.extole.com/docs/sftp-and-batch-file-conventions.