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 |
None | |
Over 24 characters | |
"coupon1,coupon2" | Comma in value |
"United States" | Space in value |
refer-a-friend | None |
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.