Difference between revisions of "Convert fixed width to CSV"

Latest revision as of 13:00, 17 August 2017

The convert to character delimited function allows you to convert a file from fixed-width columns to character delimited fields (e.g., CSV). This complements the CSV convert to fixed width feature.

The "Convert to character delimited" dialog offers the following options:

Separator Character
This specifies the delimiter character to insert between fields. Enter "^t" for a tab character.

Field Widths
This is a list of comma separated field widths used for the conversion. If there are less fields than entries, the last entry will be used as the field width for the remaining fields.

Convert
This performs the conversion from fixed column to character delimited text according to the settings above. The complete file will be converted. Please note that this may take some time for larger files.