How to add leading 0 in a particular column value to make it fixed 9 digit number

Question

Hi All,
I have a scenario in which I have to add leading 0 to make all over length as 9 of the value. If the value is of length 1 then I will add 8 zeros and if the value is of 4 digit lenght then i will add 5 zeros to make it total 9 digits as length.
For Example
Input:
1
2
16
188
1235
Output:
000000001
000000002
000000016
000000188
000001235
Please help

jcornelius · Answer

text1 = “000000000”; //length you want
text2 = “1234”;
result = “000000000”.concat(text2);
0000000001234
//returns last number of characters
let result2 = result.slice(-9); //length you want
000001234
‘0’.repeat(9).concat(text2).slice(-9)

pakhi · Answer

$value.toString().length &lt; 9? ‘0’.repeat(9 - $value.toString().length) +$value: $value
This is working

jcornelius · Answer

use .concat(‘00000000’).concat($Input).slice(-8)

pakhi · Answer

This is not working. Can you explain little more
$value : 1234
I want it as 000001234
$value : 12345
I want it as 000012345
total length = 9

Forum Discussion

How to add leading 0 in a particular column value to make it fixed 9 digit number

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?