topic Re: Replace String in Talend Studio

Replace String

tlwilli2020 — Sat, 16 Nov 2024 01:08:49 GMT

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

Re: Replace String

Anonymous — Tue, 10 Nov 2020 02:33:41 GMT

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

Re: Replace String

tlwilli2020 — Tue, 10 Nov 2020 19:35:23 GMT

Shong --

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