Wrap CSV values
Learn about how some CSV values must be wrapped to ensure their accuracy during data transformation.
Why wrap it?
When you load the data through a .csv file, you sometimes have to wrap some values for accurate data transformation. When you wrap text values together within quotes, the software perceives the wrapped value as a single value. Say when the CSV file uses the delimiter || (two pipes) and a column value in .csv has | (a single pipe), you must wrap the values that have the single | within double quotation marks.
For the full list of Reltio supported delimiters, see topic Load Entities into a Tenant.
For the original CSV specification, see RFC 4180 - Common Format and MIME Type for Comma-Separated Values (CSV) Files.
Example
col1 || col2||col3||col4Val1||val2||”val3|val4”||val5