User manual

Designing Labels
Working with Variable Data
138
13857L-003 11/29/2011
Choose Fixed if you know that your data fields always occupy the same number of characters.
Start import at row option is useful when you do not want to import some rows at the top of the
file. You may want to use this option when the text file contains a header on top of actual data
fields.
Set the Fields
Figure 73 • Database Wizard –Setting separator and delimiter
In the second step of the Text File Wizard, you have to set the fields in the text file. If you have
selected
Delimited in the previous step, choose the appropriate separator here. Commonly,
used separators are already pre-defined. But if you require some other, there is an option to use
a custom-defined one.
You can also select the Delimiter character that is used when a separator character is used in
the text field itself. The delimiter should be used to enclose this field. Text between two
delimiter characters is treated as one field although it contains the field separator character.
The data preview in the bottom part of the dialog box will let you know if your choice of a
separator character is a correct one. Fields will be separated with vertical lines if a separator is
valid.
If you selected to have your data formatted with fixed widths, the second step of the Wizard
will be slightly different. Instead of selecting a character for field separation, you will have to
define field widths. Use a mouse and draw a vertical line to the start positions of the fields.
Lines will indicate where the new field starts.