| CsvReaderUserSettingsEscapeMode Property |
Specifies how to escape an occurance of system
characters, like the
TextQualifier
and
Delimiter, inside field values
when required.
Default is
Doubled.
Namespace: DataStreams.CsvAssembly: DataStreams (in DataStreams.dll) Version: 5.20.0.0
Syntax public EscapeMode EscapeMode { get; set; }
Public Property EscapeMode As EscapeMode
Get
Set
Property Value
Type:
EscapeModeRemarks
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' |
See Also