Use the Align Fields tool to column-align the fields of lines of an input file.
Procedure
- Choose input and output files. See Force ANSI / Remove BOM.
As a visual aid, up to the first 9 lines of the input file are displayed in the Input Top area.
- Optionally,
- Change the delimiter in the Delimiter box.
When blank, a comma is used as the default delimiter.
- Change the field quote marks using the Quotes
drop-down control. The Match Fields control uses the selected quote marks.
- Select the Merge Adjacent Delimiters control.
- Select the Match Fields control.
When the Match Fields control is selected, the Enforce Strict Field
Count control is automatically selected.
- Select the Enforce Strict Field Count control.
- Select the Enclosed control.
When the Enclosed control is selected, fields within
the chosen Enclosed By characters are aligned.
- Click the Check button.
As a visual aid, the result of your settings, when applied to the lines displayed in the
Input Top area, are displayed in the Output Top area.
- Click OK to create the output file.
|