String manipulation number

Good evening guys, how are you ?

I have the Code column, it has some numbers, such as 58, 345.9, I need a column to be created where the number is 00058 for example, restricted to 5 digits. Can you help me?


Hi @Gabriel2020

In a String Manipulation node, you can use padLeft($column1$,5,"0"). The description of the function gives you more information about its behavior.


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