This content has been marked as final. Show 3 replies
If I've interpreted the statement correctly then you're wanting to pad the digits to the left of a decimal point to four characters, so 12.345 becomes 0012.345.
The easiest way to achieve this is by using an Expression processor [see the online help for full syntax details]. Assuming the input attribute is called "col1" then the following expression should acheive the desired result:
substr("000" || col1, indexof(col1, ".") - 1)
Edited by: user4362313 on May 3, 2013 4:55 AM
It does that already. You don't need to use a nested condition.