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 . |