Understanding Text Files

All text files containing data need to have some way for BarTender to tell which field belongs to an object on the template and which field belongs to another. This is done using delimitation, which refers to the use of special characters to separate the fields in the data file. Alternatively, you can specify a fixed width for every field in the data file. BarTender supports six types of text files:

• Mixed Quote and Comma

• Quote and Comma

• Comma

• Tab

• User Defined Delimiter

• Fixed Width

The default text file delimitation method is Mixed Quote and Comma. This is a mixture of quote and comma delimitation and is the most common type of delimitation used when exporting data from a database or spreadsheet to a text file. This default setting works with most delimited text files, because it supports both quote and comma delimited files and straight comma delimited files. However, when you do need to select an alternative delimitation method, change the Delimitation Type, found on the Options tab of the Database Connection Setup dialog.

Open topic with navigation