The Export Options string consists of comma-separated parameters which specify the behavior of the various export options. A typical example would be:
" Delimiter=comma; TextQualifier=singlequote "
This would set the delimiter character to a comma and the text qualifier character to the single-quote mark ( ' ).
Option |
Action |
Default |
Delimiter |
Character that separates data cell values. You can use more than one delimiter in the string. For example, " Delimiter=comma,%,tab" |
comma |
TextQualifier |
Specifies the character that surrounds cells containing text. |
doublequote |
Delimiter values:
tab |
Enter the word "tab" |
comma |
Enter the word "comma" |
semicolon |
Enter the word "semicolon" |
space |
Enter the word "space" |
other |
Enter the delimiter character in the delimiter list. For example, if your file uses percent signs to delimit data add a " Delimiter=%" to the export options string. |
TextQualifier values:
doublequote |
Enter the word " doublequote" |
singlequote |
Enter the word " singlequote" |
none |
Enter the word "none" |
other |
Enter the text qualifier in the qualifier list. For example, if your file uses percent signs to qualify text add a " TextQualifier=%" to the export options string. |