If given, then values having this symbol at the beginning and end are treated as text:
1) the text qualifier symbol is removed from the beginning and end
2) if the text qualifier symbol is doubled within the value, it is replaced with a single text qualifier symbol
example using single quote as text qualifier:
144, 12/18/2004, 'Lee''s House of Kebab', '719 High Street'
144 12/18/2004 Lee's House of Kebab 719 High Street
The default is a quote mark ("). |