Specifying a field separator

Follow these steps to insert a separator character between each field of data within a record in the transfer file. You might want to do this, for example, if transferred data is to be imported to Microsoft Excel.

1. Open the transaction description.

2. In the Transaction description dialog, click Options.

3. In the Transaction description options dialog, specify whether you want a tab, comma, or other separator between the fields. (See that dialog’s help topic for warnings and information and warnings about specific settings.)

4. Click OK twice to close the two dialogs.

Other settings that affect the output

• Justification of the output data

• Pad characters in the output data

• Data format in the output data

• Using a table to translate field values

• Certain Transfer job options