Replace to all columns

[DrGenious]

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.

[TRF]

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.

[DrGenious]

@TRF 

Where I will put the String.replaceALL() ? 

[CriticalMass]

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.

[DrGenious]

@CriticalMass  

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

[TRF · Accepted solution]

@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.

[TRF]

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