Many tools that export delimited files check the field values for control characters that are otherwise used for field delimiters, text quotes, and record terminators. If a special character is found within a field, an escape character is inserted before the special character.
Our spray process does not support escape characters. Instead, we currently go back to the source to strip quotes, and add multi-character separators and terminators.
Enhancing the spray capabilities of the HPCC to support escape characters in field values would be a helpful change.
|Document new escape option on CSV files||Resolved|