Export Option String

The Export Options string consists of comma-separated parameters that specify the behavior of the various export options. A typical example would be:

Delimiter=comma;

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.

See Also

Import Options String