How can I change 1 to 0001

HKuser · January 25, 2021, 2:09am

Hi everyone,

Here is my data set

1
12
35
456
0000751

If i want to change all the number to 7 digits
like
0000001
0000012
0000035
0000456
0000751

How can I do this? Thanks a lot!

iperez · January 25, 2021, 3:17am

Hi @HKuser you can use the String Manipulation node and use the padleft formula : padLeft($column1$, 7, “0”)

kowisoft · January 25, 2021, 6:04pm

One addition to the great tip that @iperez gave: I would suggest to do this as one of the later steps in your workflow. This allows for flexibility in case you need to calculations with those numbers.

system · March 31, 2021, 3:53am

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.