topic Re: how to use tmap expression builder for all columns required in Talend Studio

how to use tmap expression builder for all columns required

Anonymous — Mon, 03 Dec 2018 06:05:47 GMT

hello everyone

first of all thank you to every assistance i can get from this post.

I have a task to produce a delimited output that would filter out hidden characters (whitespace, newline, etc) I had chose to use row1.columnName.replaceAll("(\r\n|\n)","") to obtain my desired result. i use variable panel to achieve this. but this only works on 1 column out of a hundreds of columns i might had to handle later on. and that would be tedious and time consuming to copy paste and alter each variable i need to process. is there a simpler way to do this? thank you! ive attached a related .png for your reference

Re: how to use tmap expression builder for all columns required

Anonymous — Mon, 03 Dec 2018 07:31:30 GMT

Hi,

An easy idea will be to read the file initially using a tfileinputfullrow and clean the data for entire row in one go. Once the data is cleansed, you can you can extract the data using textractdelimited component.

I hope the answer has helped you to resolve your query. Could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhil Thampi

Re: how to use tmap expression builder for all columns required

Anonymous — Fri, 07 Dec 2018 02:45:19 GMT

hi @nthampi thank you for your guidance, im currently trying to make this job works using your suggested solution.if it works, ill be sure to mark this as resolved, thanks in advance.