TXL Wizard Options

Clicking the Options button (or ALT-O) brings up the options form. You'll notice that there are two tabs, one for input and one for output file options. Within each of the two tabs please take note that some options are specific to a conversion method.

 

Input File Option

Recipe and Marked File Specific Options

Support Unix style  text files: Use this option if your file is derived on a Unix style platform.

Tab Size: If your input file contains tabs, specify here how many spaces to replace the tab character with.  When the text in the input file contains tab characters you must specify the tab stop size that was used when the file was created. Typical values are 2 to 16, with 8 used most commonly. If your columns are not copying to Excel correctly from a tab delineated text file, try adjusting tab size.

 

Profile Method Specific Options

Input File Format: Select ASCII (8 bit) or Unicode (16 bit) file type. Default is ASCII (8 bit).

Begin to gather data at specific row/column: Here you may specify a row column to begin gathering data. Use the same format as you would when using Excel. For example: B4 = 2nd column 4th row.

Treat values as text (i.e. leave leading zeroes intact): When the text within the input file contains data beginning with a zero and converting to Excel, Excel will truncate the leading zero. Try this option to overcome this issue and retain the leading zeros.

 

Output File Options

Output Excel File

Clear sheet contents before processing: When checked, output sheet data will be cleared before processing. If unchecked the contents will not be cleared before processing, and cells will be overwritten if the input and output files share cells in common. For example, if the output file has data in cells A1:F20 before processing, and the input file has data in cells A1:F6 then after processing the data in A1:F6 will be from the input sheet, with all data in cells A7:F20 remaining unaltered.

Note: This option is only applicable to Excel files. Output CSV files will always be cleared before processing.

Note: This option does not work with the Profile method. The Profile method always removes any existing Excel file.

 

Output CSV File

Delimitation Character: If you are converting to a CSV file you can choose any character to distinguish each piece of data. Most often the comma is specified but the tab and bar | character are also very popular. See the ASCII Chart for a full list of potential delimitation characters.

 

Profile Method Specific Options

Use Double Quotes:

If you don't like the way in which double quotes are used to generate an output file, here you may specify exactly what you want. The following options are available:

Remove extra pad character(s) from the output file: Enabled by default. Disable this option if you wish to retain your padding characters in the output file. The padding character is typically the space character, though could be anything. See Fixed Width Text File Defined for more information.