Text File

When you select Text File as the Database Platform in the Add Database Connection Wizard, you need to select the text file to read from and set up how you want BarTender to read the text file. You can accomplish these tasks using the following Add Database Connection Wizard pages:

Select the text file to read from

To begin setting up your text file connection to BarTender , you must specify the text file to read from and its character set.

• Enter the name of the text file to read from. Specifies the path and file name of the desired text file. Alternatively, to navigate to the file on your computer or network, click Select File.
• Select File. Opens the Specify Text File dialog, which allows you to navigate to the directory location of the desired text file.
• View File. Opens the specified text file in the default text editor.
• Encoding. Specifies the character set of the text file.

Once you have selected your text file and its character set, click Next for the next step in the wizard.

Specify field delimitation

After selecting your text file and its character set, you need to specify the field delimitation type so that BarTender can read data from your file correctly. Using this dialog, you can set the delimitation type and view your file.

• Delimitation Type. Specifies the type of delimitation. Select from the following options:
  • Mixed Quote and Comma
  • Quote and Comma
  • Comma
  • Tab
  • User Defined Delimiter
  • Fixed Width

  Once you have selected your text file delimitation type, click Next for the next step in the wizard.

  Select the format of the first row

  After selecting your text file delimitation type, you need to specify whether the first record of the text file is a header that contains the names of the fields. If you are not certain, you can view the text by selecting the View File button.

  For example, the first record of the following text file is a header that contains the names of the fields:

  "V037","FROZEN","(G — General Audiences)","BLU-RAY"

  "V061","APOLLO 13","(PG13 — No One Under 13)","DVD"

  Once you have answered Yes or No, click Finish to complete the Add Database Connection Wizard.

  

  When you are reading data in from a text file without field names, BarTender reads the fields in each record of your data file from left to right. For example, if you select "Field 3", BarTender will (at print-time) replace the sample data for the currently selected object with the data from the third field in your data file.

  Related Topics