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)