Truncating Number Fields When Converting Strings to Numbers

Edit online

By default, the translator trims all trailing zeros from output values. This behavior is not desirable for financial standards such as SWIFTNet, for which trailing zeros represent a specific amount for a particular currency.

Therefore, the storage.keepTrailingZeros property in the customer_overrides.properties file enables you to specify whether or not trailing zeros are kept on any numeric field on the output side of the map (numeric fields that have been converted to strings).

By default trailing zeros are trimmed (storage.keepTrailingZeros=false). If you set this property to true, this will preserve trailing zeroes. Therefore, by default the value 3.142000 is truncated to 3.142, but if you set the storage.keepTrailingZeros property to true, the resulting string value is 3.142000.

Note: For some applications (for example, SWIFTNet, finance, and so forth), the behavior of keeping trailing zeroes may not be desirable.

Truncating Trailing Zeros in a Specific Map

You can choose to truncate trailing zeros in a specific map by setting the storage.mapName.keepTrailingZeros property in the customer_overrides.properties file, using the following syntax:


storage.mapName.keepTrailingZeros=true

In this syntax, mapName refers to the content of the Description field when you access the Map Details (Edit > Details) for the map in which you want to truncate trailing zeros. The value true indicates that you want to preserve trailing zeros for the specified map, and false indicates that you want to truncate trailing zeros for the specified map.