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...
Solved! Go to Solution.
Use a build string action and the inline function of PadLeft
where 3 is the length of your required string and 0 is the character to pad.
Hope this helps
build string padleft leading zeros