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?
I am sure this is a new feature request, there already exists a jira issue.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend
Test drive Talend's enterprise products.