topic Re: Data Handling using TMAP in Talend Studio

Data Handling using TMAP

daez — Wed, 04 Nov 2020 09:03:53 GMT

Hello dear community,

I'm trying to modify data using TMAP but i have no idea how to use a IF/COUNT condition.

Input column : >>>>> Output needed :

112345 >>>>> 0000112345

11240 >>>>> 0000011240

110247 >>>>> 0000110247

142 >>>>> 0000000142

I need it to count the char and fill it with 0 or blank until it reach a given count, like 10 for this example.

Any help appreciated !

Anonymous — Wed, 04 Nov 2020 09:19:12 GMT

Try this expression on tMap.

String.format("%010d", row1.columnName)

Regards

Shong

daez — Wed, 04 Nov 2020 13:39:45 GMT

Hello shong,

Thanks for the help !

This is what im getting :

Data type is String only on TALEND. The excel im getting data from isnt in integer.

My data we talking about looks like :

20190-002

MA01547

I tried adding String.valueOf() but having exact same error again :

String.format("%010d",String.valueOf(row1.newColumn1))

Thanks for your knowledge

Anonymous — Thu, 05 Nov 2020 02:54:25 GMT

If your data is a string, try this

org.apache.commons.lang.StringUtils.leftPad(row1.columnName, 10, "0")

daez — Fri, 06 Nov 2020 08:37:04 GMT

Hello @Shicong Hong ,

I got an error using ur last idea. Might be from a JAR files missing. I find my hapiness with StringHandling.LPAD(row1.lotfourni, 20, " ")

THANKS.