Text (Delimited) Destination

Output Text File Path

Specify the folder and file name for the Text file in which the extracted data will be stored.

File Save As Dialog Button

Click this button to use the Windows File Save As dialog to specify the full path to the destination text file.

Overwrite Text File if it Already Exists

Set this option to true (checked) to have the extract process overwrite the destination file if it already exists.

If set to false (unchecked) and the file already exists, the extractor process will terminate with an error message.

Column Delimiter

Specify how columns in the output are separated from one another by selecting one of the following options:

Comma Separated

Each column’s data is separated from the next column by a comma.

Tab Separated

Each column’s data is separated from the next column by a Tab.

Other Separator

Each column’s data is separated from the next column by the character or characters you specify here..

NOTE: Last column on a line is separated from the next line’s first column by the line terminator.

Line Terminator

Specify how the output lines with be separated from one another.

CR/LF

Select this to insert the standard Carriage Return/Line Feed at the end of each output line.

Other Line Terminator

Each line of output data will be separated from the next column by the character or characters you specify here.

Include Column Names on First Line of Output

Set this option to true (checked) to write column names to the first line of the output file..

String Values Surrounded with Quotation Marks

Set this option to true (checked) to place double-quotes at the beginning and the end of string values.

When this option is set to true (checked) the double-quotes are not included in the data value for the column.

Example:

Column text = “Washington D.C.”

If String Values Surrounded with Quotation Marks = true (checked)

Column value is Washington D.C. (no quotes)

If String Values Surrounded with Quotation Marks = false (unchecked)

Column value is “Washington D.C”. (quotes included in value)