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...
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
It works fine!
Thank you very much and have a nice day!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.