Golden Software Data Export Automation Options

 

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

Save As