cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

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

Pakhi
New Contributor III

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

4 REPLIES 4

jcornelius
New Contributor III

use .concat(โ€˜00000000โ€™).concat($Input).slice(-8)

Pakhi
New Contributor III

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

Pakhi
New Contributor III

$value.toString().length < 9? โ€˜0โ€™.repeat(9 - $value.toString().length) +$value: $value

This is working

jcornelius
New Contributor III

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)