Hi Bala,

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)

regards,
Nick

Bala,

It does that already. You don't need to use a nested condition.

regards,
Nick