topic Re: Find the best string result in QlikView https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088212#M362147 <HTML><HEAD></HEAD><BODY><P>Thx <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> ! </P></BODY></HTML> Thu, 17 Mar 2016 07:16:42 GMT 2016-03-17T07:16:42Z Find the best string result https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088209#M362144 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Sorry for my english <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> !</P><P></P><P><SPAN lang="en">My problem is this :<BR />I have a client list with a city and postal code entered manually , </SPAN></P><P><SPAN lang="en">and I want to match it with a file of cities.<BR />My problem is this :</SPAN></P><P><SPAN lang="en"> some cities entered are bad spelled .<BR />I want to match with the city that is match more .<BR /><BR />Example: </SPAN></P><P><SPAN lang="en">Montbelliard ---&gt; Montbeliard (In list have : <SPAN style="font-size: 13.3333px;">Montbeliard - <SPAN style="font-size: 13.3333px;">Montbeliardot - Courcelles les montbeliard)</SPAN></SPAN><BR />Plessis pate - &gt; Le plessis plate<BR /><BR /><BR />Thank you <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Wed, 16 Mar 2016 13:57:06 GMT https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088209#M362144 2016-03-16T13:57:06Z Re: Find the best string result https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088210#M362145 <HTML><HEAD></HEAD><BODY><P>search for the following terms in this community:</P><P></P><P>Metaphone</P><P>Soundex</P><P>Levenshtein</P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 17 Mar 2016 00:26:47 GMT https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088210#M362145 MarcoWedel 2016-03-17T00:26:47Z Re: Find the best string result https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088211#M362146 <HTML><HEAD></HEAD><BODY><P>Can you match it using the postal code?</P></BODY></HTML> Thu, 17 Mar 2016 00:34:33 GMT https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088211#M362146 swuehl 2016-03-17T00:34:33Z Re: Find the best string result https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088212#M362147 <HTML><HEAD></HEAD><BODY><P>Thx <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> ! </P></BODY></HTML> Thu, 17 Mar 2016 07:16:42 GMT https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088212#M362147 2016-03-17T07:16:42Z Re: Find the best string result https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088213#M362148 <HTML><HEAD></HEAD><BODY><P>Impossible because some cities have the same postal code <span class="lia-unicode-emoji" title=":confused_face:">😕</span></P></BODY></HTML> Thu, 17 Mar 2016 07:18:16 GMT https://community.qlik.com/t5/QlikView/Find-the-best-string-result/m-p/1088213#M362148 2016-03-17T07:18:16Z