Open topic with navigation

When reading information from a database, you may not want an the entire contents of a database field to be read into an object on the template. For example, you may have a database field that contains leading or trailing spaces before or after the desired data. This can be caused by converting from one database format to another or from a database to a text file. Since BarTender doesn’t know whether the spaces are necessary or not, they will be treated as data at print-time, increasing the size of a barcode.

You can access this dialog in one of the following ways:

• Click next to Truncation on the Transforms tab of the Data Sources property page (for template objects).

• Click next to Truncation on the More Query Prompt Options dialog (for query prompts).

Truncation

• Trim spaces on left: When enabled, removes unwanted leading spaces.

• Trim spaces on right: When enabled, removes unwanted trailing spaces.

• Discard characters on left: When enabled, removes the specified number of characters 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: When enabled, removes the specified number of characters 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: When enabled, retains the specified number of characters on the left side of the selected data source; all other characters are truncated.

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

• Keep characters on right: When enabled, retains the specified number of characters on the right side of the selected data source; all other characters are truncated.

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

• Strip ".0" or ",0" from value: When enabled, removes any zeros after the period of comma from the right side of the selected data source.