One Star

Replacing multiple fields at once using treplace component

Hi,
I have been trying to use the treplace component of talend 5.1.1 version to replace in input file and get a output file like the images provided and used treplace component properties as in image but not able to get it while if i give separately for all string then i am able to get the output.
I want to use the pipe operator as 'or' for search column and then want to replace it.
In above senario replacement is happening for "." and "$" but not for others.
1 REPLY
Community Manager

Re: Replacing multiple fields at once using treplace component

Hi
Check the "Advanced mode" box and search with regexp pattern to support pipe operator such as "or " and complex expression.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business