treplacelist to match whole string

Highlighted
Four Stars

treplacelist to match whole string

Hello everyone!

I am using Open Studio for Data Integration

There is a sales data in which I have Sub_Category_name. There are various spelling mistakes in it. So I am using treplacelist to rectify them.

Now the problem is there are spellings like Leggins, Leggin, Legging which should be replace by Leggings.

treplacelist is matching only a part of the string and replacing it, not looking at the whole spelling.

So I want my treplacelist to only replace with the replacement column when it finds the exact match of the whole string, not a part of it.

How to achieve this?

Highlighted
Community Manager

Re: treplacelist to match whole string

Hi
I am sure this is a new feature request, there already exists a jira issue.
https://jira.talendforge.org/browse/TDI-30413

Regards
Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads