Skip to main content Link Search Menu Expand Document (external link) Copy Copied

CSVdialect

Class module developed to share CSV dialects, or group of specific and related configuration, which instructs the parser on how to interpret the character set read from a CSV file. This container travels through the parsing and sniffer methods.


Members

Item Type Description
escapeMode Property Gets or sets the escape behavior. The default value of this property is EscapeStyle.rfc4180 and instructs the parser to escape fields according to RFC-4180 specs, if EscapeStyle.unix is used it will instruct the parser to escape special characters ALSO in Unix style by preceding those characters with a backslash \.
fieldsDelimiter Property Gets or sets the character to be used to delimit the fields in the target CSV/TSV file. The default value of this property is comma , but the user can specify any character as field delimiter. However, it is advisable to use commonly used characters such as colon :, semicolon ;, pipe | and tab vbTab.
quoteToken Property Gets or sets the char that will be used for quote those fields containing some CSV/TSV syntax special char. The user must use the QuoteTokens enumeration to define this property. The user can choose between double quotes ", single quote ' and tilde ~.
recordsDelimiter Property Gets or sets the char that will be used for delimit records in the target CSV/TSV file. The default value is vbCrLf, but user can choose one of vbCr and vbLf.

Back to API overview