How can I change 1 to 0001

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!

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

11 Likes

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.

2 Likes

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