Specifies how to escape an occurance of system characters, like the TextQualifier and Delimiter, inside field values when required. Default is Doubled.
When the EscapeMode is set to Doubled, occurances of the TextQualifier will be expected to be escaped by replacing it with two consecutive occurances of the TextQualifier. This is the format generally used for CSV in applications such as Excel. When the EscapeMode is set to Backslash, occurances of the TextQualifier will be expected to be escaped by preceding it with a backslash character. This format is common in Unix type environments. When the EscapeMode is set to Backslash, the following escape sequences are also recognized and replaced inside field values.
| Escape | Description |
|---|---|
| \n | New Line, ASCII 10 |
| \r | Carriage Return, ASCII 13 |
| \t | Tab, ASCII 9 |
| \b | Backspace, ASCII 8 |
| \f | Form Feed, ASCII 12 |
| \e | Escape, ASCII 27 |
| \v | Vertical Tab, ASCII 11 |
| \a | Alert, ASCII 7 |
| Format | Description |
|---|---|
| \u#### or \U### | Unicode, ex. \u0041 = 'A' |
| \x## or \X## | Hexadecimal, ex. \x41 = 'A' |
| \o### or \O### or \### | Octal, ex. \o101 = 'A' |
| \d### or \D### | Decimal, ex. \d065 = 'A' |
CsvDataReader.UserSettings Class | DataStreams.Csv Namespace