topic Re: How to replace all strings in a column with a string of specific length using tmap component in Talend Studio

How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 15 Nov 2024 23:36:08 GMT

Say I want to replace all values in a column with a value of specific length in that column.

For this input column I only want my output to have "ABCDEFGHIJKL" for one column. How do I do this?

Re: How to replace all strings in a column with a string of specific length using tmap component

gjeremy1617088143 — Fri, 22 Oct 2021 13:22:51 GMT

Hi, in the tMap you made no link between the input and output column you want with a fixed value and in the output field you add the value you want. ex "ABCDEFGHIJKL" and all the values of this column will be "ABCDEFGHIJKL".

send me love and kudos

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 22 Oct 2021 14:08:18 GMT

Thanks but What if the value is not fixed since the job im making iterates through different files?

Re: How to replace all strings in a column with a string of specific length using tmap component

gjeremy1617088143 — Fri, 22 Oct 2021 14:40:25 GMT

does the lengh is fixed and is the condition to find the value ?

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 22 Oct 2021 14:44:59 GMT

yes the length is fixed. Attached are the input and output table

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 22 Oct 2021 14:46:03 GMT

"ABCDEFGHIJKL" is a sample SEIN

Re: How to replace all strings in a column with a string of specific length using tmap component

gjeremy1617088143 — Fri, 22 Oct 2021 14:51:37 GMT

are you able to read data with talend and if yes could you send the content of the talend input?

Re: How to replace all strings in a column with a string of specific length using tmap component

gjeremy1617088143 — Fri, 22 Oct 2021 14:55:40 GMT

you can read the file a first time :

set a global var in a tjavarow :

if(input_row.(yourfield)!=null && StringHandling.LEN

(input_row.(yourfield))==(your lengh value)

globalMap.put("SEIN",input_row.(yourfield));

then your read it again and in the tmap output you can set the value with (String)globalMap.get("SEIN")

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 22 Oct 2021 14:59:21 GMT

Here it is and tmap table. Thanks!

Re: How to replace all strings in a column with a string of specific length using tmap component

gjeremy1617088143 — Fri, 22 Oct 2021 15:06:03 GMT

so do the same you have in tmap but just put the SEIN column in output and add a filter condition on output ("SEIN").equals(row2.A)

and in SEIN column value row2.B.

then you add a tSetGlobalVar after the tmap with a main link (with key "SEIN" and value out.SEIN)

then you read again your file and you can use globalMap.get("SEIN") to set the value to all the values of the column

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Fri, 22 Oct 2021 15:19:10 GMT

Thank you so much!

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Sat, 23 Oct 2021 14:02:25 GMT

Sorry am still a newbie at talend. Do I still do this code: if(input_row.(yourfield)!=null && StringHandling.LEN

(input_row.(yourfield))==(your lengh value)

globalMap.put("SEIN",input_row.(yourfield));

And how can I put a filter condition or do this:

("SEIN").equals(row2.A)

and in SEIN column value row2.B.?

Re: How to replace all strings in a column with a string of specific length using tmap component

JABELLA1634831127 — Sun, 24 Oct 2021 11:21:20 GMT

Hi so I was able to input a t_java_row but when I ran the job, the output would only show the column header SEIN. Attached are pictures for reference.