tMap Pad String with Leading 0

[Anonymous]

I have been wrestling with this all day.  StringHandling.LPAD(row2.SAP_ID, 6, "0")  tests without error in the Expression Builder however isn't inserting the leading 0's in my field.  Any suggestions?

Many thanks!

[manodwhb]

@lli , you can do below way also.

here id column data type is string , 30 is length of string and 0 is the padding character.

StringHandling.LPAD(row3.id,30,"0")

[Vijay_K_N]

in talend 7.1 i didn't find lpad function in string handling category

[manodwhb]

@lli , you can find this in under Code>>Routines>>system>>StingHandling.

[Vijay_K_N]

i followed ur suggestions but when i open the string handling i got program window in that every string handling function is there ...so u mean i can use ryt ...so why in tmap they are not available ???

[Anonymous]

It works Perfectly may i get Explanation of ("%1$9s",) this

[Anonymous]

It works Perfectly may i get Explanation of ("%1$9s",) this