Replace String

[tlwilli2020]

Here is my situation. We are getting data pushed into a Snowflake staging database from a 3rd party vendor (column stored as a string). It seems to have replaced the special characters such as & and apostrophes with their numerical equivalent:

For example:

ABC's Market --> ABC

's Market

A & B Sales --> A & B Sales

Is there any built-in Talend component that will convert these for me? Or is the only real option to write some code to replace them. Appreciate the guidance.

Thanks

[Anonymous]

Hi

Take a look at the tReplace component which you can configure the search/replace expression. Let me know if it meets your need.

Regards

Shong

[tlwilli2020 · Accepted solution]

Shong --

Thank you. I believe using the tReplacementList option will definitely work. See attached screenshot.