Open topic with navigation

When information is read from a database, you might not want the entire contents of a database field to be read into an object on the template. For example, suppose that your database has a field that contains leading or trailing spaces before or after the data that you want to print. (This condition can be caused when you convert one database format to another or convert a database to a text file.) Because BarTender cannot determine whether the spaces are necessary, the spaces are treated as data at print time, which increases the size of a barcode.

To access this dialog, use one of the following methods:

• For template objects, click next to Truncation on the Transforms tab of the Data Sources property page.

• For query prompts, click next to Truncation on the More Query Prompt Options dialog.

The following options are available.

Truncation

• Trim spaces on left: Specifies that unwanted leading spaces are removed.

• Trim spaces on right: Specifies that unwanted trailing spaces are removed.

• Discard characters on left: Specifies that the specified number of characters are removed from the left side of the selected data source.

  • Number of characters to discard: Specifies the number of characters to remove from the left side of the data source.

• Discard characters on right: Specifies that the specified number of characters are removed from the right side of the selected data source.

  • Number of characters to discard: Specifies the number of characters to remove from the right side of the data source.

• Keep characters on left: Specifies that the specified number of characters on the left side of the selected data source are retained and all other characters are truncated.

  • Number of characters to keep: Specifies the number of characters to retain on the left side of the data source.

• Keep characters on right: Specifies that the specified number of characters on the right side of the selected data source are retained and all other characters are truncated.

  • Number of characters to keep: Specifies the number of characters to retain on the right side of the data source.

• Strip ".0" or ",0" from value: Specifies that any zeros after the period or comma are removed from the right side of the selected data source.