Characters such as quotes, backslashes, and certain symbols, can have special meaning. For example, a ; used as a separator can denote the end of a field value in a CSV file. In this case, the add-on knows to import the value after the ; into the next field. When data values include special characters, they should be escaped so that they are treated as literal characters rather than having special meaning. During the data integration process, you can specify the separators and delimiters used to ensure that data imports correctly. However, please note that the add-on reserves use of the backslash (\) character in order to support multi-valued fields. Due to this, you should avoid specifying a list separator character that is also used in data values.
The following shows an example of how the \ character is handled by the add-on:
When data contains the \ character:
When exporting a value of 100\000, it becomes 100\ \000.
When importing a value of 100\,000, it becomes 100,000.
When data includes the selected list separator, for example, the space character as shown below:
When exporting a value of 100 000, it becomes 100\ 000.
When importing a value of 100\ 000, it becomes 100000.