How to format a number to a three characters string

+3

Dear all:

I have a number between 0 and 999, and I would like to format it as follow:

If <10: 00X

If >=10 and <100: 0XX

If >99: XXX

it means, to have a three characters string to allow to be sort properly...

I don't know if using regular expression I can do it...

Thank you very much in advance...

+7

Use a build string action and the inline function of PadLeft

fn-PadLeft({YourNumber},3,0)

where 3 is the length of your required string and 0 is the character to pad.

Hope this helps

build string‌ padleft‌ leading zeros‌

+3

It works fine!

Thank you very much and have a nice day!

Sign up