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?
