topic Re: Replace to all columns in Talend Studio

Replace to all columns

DrGenious — Thu, 23 Jan 2020 10:59:04 GMT

Hello,

I have a file with 16 columns. Most of these columns have special characters ^~. I want to erase these symbols from all columns but I dont want to go in every column and put replaceAll(). I want to find a way to apply this method (.replaceAll()) one time and catch all columns.

Thanks a lot.

Re: Replace to all columns

TRF — Thu, 23 Jan 2020 12:26:05 GMT

Read your input file with tFileInputRaw or tFileInputFullRow. It will give you every record as a single column in which you can go with String.replaceAll to operate the substitution. Then create a new output file and get this one to proceed with the rest of the job.

Re: Replace to all columns

DrGenious — Thu, 23 Jan 2020 13:11:12 GMT

@TRF

Where I will put the String.replaceALL() ?

Re: Replace to all columns

CriticalMass — Thu, 23 Jan 2020 13:19:43 GMT

Hi,

you could just use tFileInputFullRow -- tJavaRow -- "someOutPut" like in the follwoing screenshot...of course you can do type conversions etc. in the Java Code.

Re: Replace to all columns

DrGenious — Thu, 23 Jan 2020 13:29:50 GMT

@CriticalMass

Thanks a lot for your answer. The only wαy to achieve this is with array?

Re: Replace to all columns

TRF — Thu, 23 Jan 2020 13:39:17 GMT

@DrGenious, as in the other example, use a tJavaRow:
tFileInputRaw --> tJavaRow --> tFileOutputRaw
Here is the expression you have to use:

output.content = input.content.replaceAll("\^~", "");

Other solution is good as you don't have read the file twice but if data contains the field separator character, it will not work as expected.

Re: Replace to all columns

TRF — Sun, 26 Jan 2020 18:17:44 GMT

@DrGenious, did this help?
If so, thanks to mark your case as solved (Kudos also accepted).