hello I need to convert a number that is 4 to 04 however I already have numbers like 28 that need to remain the same and not 028 thanks
for example i need 9 convert 09 and 10 = 10
Hi @Jalvear
Step 1: ‘Math Formula’ node
$number$ + 100
Step 2: ‘Number to String’ node
Step 3: ‘String Manipulation’ node
substr($number$, 1)
BR
Hi @Jalvear
Could you please precise whether your column is originally in string format or in numerical (integer, long, etc.) ?
@gonhaddock when looking at your solution (which btw is a nice trick ;-)) I wonder whether @Jalvear numbers go beyond 99 value
Best
Ael
wow amazing solution, thanks!
they are date values so this solution works wonders for me
Good to know it ! Great then
Good touch @aworker !
You can just add 1 000, 10 000 … depending on the length of your string.
BR
PS.- we can describe it as ‘adding zeros to the left’
I love this trick lol !
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.