Since the GSI Data Export Options dialog is not displayed when the program is driven from an automation script, an options string can be specified in the script. The 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. |
See Also