Truncation Dialog |
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
The Truncation dialog, accessible from the Transforms tab of the Data Source property page, allows you to specify which characters to keep or remove.
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.