https://community.qlik.com/t5/Data-Quality/treplacelist-to-match-whole-string/m-p/2268734#M2390 <P>Hello everyone!</P> <P>I am using Open Studio for Data Integration</P> <P>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.</P> <P>Now the problem is there are spellings like Leggins, Leggin, Legging which should be replace by Leggings.</P> <P>treplacelist is matching only a part of the string and replacing it, not looking at the whole spelling.</P> <P>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.</P> <P>How to achieve this?</P> Sat, 16 Nov 2024 03:17:46 GMT Anonymous 2024-11-16T03:17:46Z https://community.qlik.com/t5/Data-Quality/treplacelist-to-match-whole-string/m-p/2268734#M2390 <P>Hello everyone!</P> <P>I am using Open Studio for Data Integration</P> <P>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.</P> <P>Now the problem is there are spellings like Leggins, Leggin, Legging which should be replace by Leggings.</P> <P>treplacelist is matching only a part of the string and replacing it, not looking at the whole spelling.</P> <P>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.</P> <P>How to achieve this?</P> Sat, 16 Nov 2024 03:17:46 GMT https://community.qlik.com/t5/Data-Quality/treplacelist-to-match-whole-string/m-p/2268734#M2390 Anonymous 2024-11-16T03:17:46Z https://community.qlik.com/t5/Data-Quality/treplacelist-to-match-whole-string/m-p/2268735#M2391 <P>Hi <BR />I am sure this is a new feature request, there already exists a jira issue.<BR /><A href="https://jira.talendforge.org/browse/TDI-30413" target="_blank" rel="noopener nofollow noopener noreferrer">https://jira.talendforge.org/browse/TDI-30413</A><BR /><BR />Regards<BR />Shong</P> Fri, 14 Feb 2020 08:44:59 GMT https://community.qlik.com/t5/Data-Quality/treplacelist-to-match-whole-string/m-p/2268735#M2391 Anonymous 2020-02-14T08:44:59Z