Special Characters and Escape Characters
Special Characters
Import Rx is designed to fully support special characters and non-ASCII symbols during the import process.
Key Points
- The system should allow or properly sanitize special characters like @, #, %, &, €, and other non-ASCII symbols.
- Exact Insertion: For all text fields (Text, Text Area, Text Area Long, and
Text Area Rich), the value will be inserted into the Big Table record
exactly as it appears in the file. For example:
- John@work.com
- Flat #5, 50% Off
- A&B Traders
- Price: 100€
- (é, ü, ñ, å)
| Field Type | Data in the .csv or .txt File | Data Inserted into the Big Table Record |
|---|---|---|
|
Text, Text Area, Text Area Long, and Text Area Rich |
John@work.com Flat #5, 50% Off A&B Traders Price: 100€ (é, ü, ñ, å) |
John@work.com Flat #5, 50% Off A&B Traders Price: 100€ (é, ü, ñ, å) |
Escape Characters
When escape characters and special formatting are present in .csv fields during
import to the Big Table for text fields — e.g., \n,
\", and \\ — they should be
preserved exactly as they appear in the .csv file. The double quotes
(") used for enclosing text in the .csv file are removed
automatically after import.
| Field Type | Data in the .csv or .txt File | Data Inserted in the Big Table Record |
|---|---|---|
| Text, Text Area, Text Area Long, and Text Area Rich | "test the\n, text\, for lines\\Test" | test the\n, text\, for lines\\Test |
Tip:
The system does not split the text to the next line.