Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.
0683p000009MDUA.png 0683p000009MDUF.png 0683p000009MD6O.png
Labels (2)
1 Reply
Anonymous
Not applicable
Author

Hi
Check the "Advanced mode" box and search with regexp pattern to support pipe operator such as "or " and complex expression.
Shong