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

Consider that columns - col1, col2, col3, and col4 are delimited or separated by double pipes. The value corresponding to col3 has two values separated by a single pipe. So, the value for column 3 must be wrapped within double quotes as shown in the following:

col1 || col2||col3||col4Val1||val2||”val3|val4”||val5

You've found your way to a temporary environment. Content is not complete or final. Looking for Reltio documentation? Go to docs.reltio.com.

© 2024 The RELTIO® mark is a registered trademark of Reltio, Inc. in the United States and other countries; DataDriven and Reltio Data Cloud are trademarks of Reltio, Inc. Other names or marks are trademarks of their respective owners.

Terms, Privacy Policy, and

Unify and manage your data

Wrap CSV values

Why wrap it?

Example

Footer