You’re offline. This is a read only version of the page.
91
This was used in a "select" step
Expression : formatNumber(int(item()['Number']), '0000000')
This will add '00' in front of a 5 digit number
Hi There,
If you're already utilizing the formatNumber function as in the given expression, ensure the second argument represents the desired number of total digits. For instance, if you have a 5-digit number and you want two leading zeros, the format should have 7 characters in total.
formatNumber(int(item()['Number']), '0000000')
Make sure item()['Number'] is of type integer. If it's already an integer, the conversion with int() is redundant.
Using this method will prefix the number with the necessary zeros to ensure the number has a total of 7 digits.
Please give kudos and mark as solution if it helps.
Thanks,
Sandeep Mishra
Share
Report
All responses (
Answers (
