String columns are trimmed when starting with 0

Owned by svitlana (Deactivated)
Last updated: Jul 30, 2018
1 min read

Problem

When referring a string column in a formula, and the value of the string column is composed of numbers, starting with a '0', the value is interpreted as a number.



Consider following configuration

... col.domainref = Domain Reference col.domainref.type = string ... col.genref = MRM Reference col.genref.type = string col.genref.formula = {domainref}



When the content of domainref is for instance 010, the value of the genref column will be 10.  The string value 010 is interpreted as a number 10.  The column genref will therefore contain the string 10.

 

Workaround

Provide a hint to the formula parser that the dependent column value should not be interpreted as a number as follows

... col.domainref = Domain Reference col.domainref.type = string ... col.genref = MRM Reference col.genref.type = string col.genref.formula = "" + {domainref}