topic Re: tMap Pad String with Leading 0 in Talend Studio

tMap Pad String with Leading 0

Anonymous — Fri, 11 Aug 2017 18:39:49 GMT

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!

Re: tMap Pad String with Leading 0

TRF — Fri, 11 Aug 2017 20:11:43 GMT

Strange! Did you check using tLogRow or something else? Can you share your component configuration?

Re: tMap Pad String with Leading 0

Anonymous — Fri, 11 Aug 2017 20:16:59 GMT

Re: tMap Pad String with Leading 0

TRF — Fri, 11 Aug 2017 20:55:47 GMT

Pad methods are unavailable from TOS 6.4.1, so I can't try but you can do what you want with:

StringHandling.RIGHT("000000" + row2.code, 6)

It works.

Re: tMap Pad String with Leading 0

Anonymous — Fri, 11 Aug 2017 21:17:38 GMT

Alllllll day......... Thank you so much!!!!! That did it!

Re: tMap Pad String with Leading 0

TRF — Fri, 11 Aug 2017 21:58:47 GMT

You're welcome.
Please, don't forget to mark the solution as accepted.
Kudos are also accepted.

Re: tMap Pad String with Leading 0

vapukov — Sat, 12 Aug 2017 07:33:15 GMT

other solution - is add to project routines library StringUtils from Exchange (plus dependencies - Apache common-lang-2.6)

it include many useful function and handle null values more proper than some Talend functions

 * StringUtils.leftPad(null, *, *)     = null	
 * StringUtils.leftPad("", 3, 'z')     = "zzz"	
 * StringUtils.leftPad("bat", 3, 'z')  = "bat"	
 * StringUtils.leftPad("bat", 5, 'z')  = "zzbat"	
 * StringUtils.leftPad("bat", 1, 'z')  = "bat"	
 * StringUtils.leftPad("bat", -1, 'z') = "bat"

and use it in tMap

it work

Re: tMap Pad String with Leading 0

Vijay_K_N — Sun, 22 Sep 2019 10:27:00 GMT

i dont know how much zeros i want to add ,if the account number length is 11 than i want to load otherwise i want to add zeros prefix the account number ??how to solve this

Re: tMap Pad String with Leading 0

Anonymous — Wed, 25 Sep 2019 04:15:48 GMT

@lli

A quick solution is as shown below.

The function used is as shown below where 11 is the length of the output string. If its less than 11, zeros will be padded to the left.

String.format("%1$11s", row1.data).replace(' ', '0')

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tMap Pad String with Leading 0

Vijay_K_N — Wed, 11 Dec 2019 05:00:21 GMT

where is the talend.format option in tmap (string handling i am using talend 7.1)

@nthampi wrote:

@lli

A quick solution is as shown below.

The function used is as shown below where 11 is the length of the output string. If its less than 11, zeros will be padded to the left.
String.format("%1$11s", row1.data).replace(' ', '0')
Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: tMap Pad String with Leading 0

manodwhb — Wed, 11 Dec 2019 12:44:38 GMT

@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")

Re: tMap Pad String with Leading 0

Vijay_K_N — Fri, 13 Dec 2019 04:02:29 GMT

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

Re: tMap Pad String with Leading 0

manodwhb — Fri, 13 Dec 2019 05:36:21 GMT

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

Re: tMap Pad String with Leading 0

Vijay_K_N — Sat, 14 Dec 2019 14:18:37 GMT

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 ???

Re: tMap Pad String with Leading 0

Anonymous — Wed, 01 Jul 2020 15:02:30 GMT

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

Re: tMap Pad String with Leading 0

Anonymous — Wed, 01 Jul 2020 15:02:30 GMT

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