topic Wildcard normalization in QlikView https://community.qlik.com/t5/QlikView/Wildcard-normalization/m-p/167241#M38884 <HTML><HEAD></HEAD><BODY><P>I am trying to normalize vendor names from an Excel file and at the moment this is done by joining with a table having FromName and ToName. I then select field depending on whether the join matched or not:</P><P>IF(NOT IsNull(ToName),ToName,vendor) AS vendor,</P><P>But since the data is rapidly growing and most names start the same and differs only in the end (Inc., Ltd., etc) I would like to do this using with wildcard, e.g. VendorName* =&gt; VendorName. That way, with one row I could normalize all data starting with VendorName into just VendorName.</P><P>Anyone have a good clue how to do this? If I could use regular expression, that would be even better. I already have a regular expression replace function in VbScript, but I don't know how to loop and use it...</P><P>Please try to be as clear as possible seeing as I am new to QlikView with a background in PHP, Java and SQL with fair knowledge in VB.</P><P>Many thanks in advance!</P><P>Sincearly, Jörgen</P></BODY></HTML> Wed, 26 Aug 2009 21:35:37 GMT 2009-08-26T21:35:37Z Wildcard normalization https://community.qlik.com/t5/QlikView/Wildcard-normalization/m-p/167241#M38884 <HTML><HEAD></HEAD><BODY><P>I am trying to normalize vendor names from an Excel file and at the moment this is done by joining with a table having FromName and ToName. I then select field depending on whether the join matched or not:</P><P>IF(NOT IsNull(ToName),ToName,vendor) AS vendor,</P><P>But since the data is rapidly growing and most names start the same and differs only in the end (Inc., Ltd., etc) I would like to do this using with wildcard, e.g. VendorName* =&gt; VendorName. That way, with one row I could normalize all data starting with VendorName into just VendorName.</P><P>Anyone have a good clue how to do this? If I could use regular expression, that would be even better. I already have a regular expression replace function in VbScript, but I don't know how to loop and use it...</P><P>Please try to be as clear as possible seeing as I am new to QlikView with a background in PHP, Java and SQL with fair knowledge in VB.</P><P>Many thanks in advance!</P><P>Sincearly, Jörgen</P></BODY></HTML> Wed, 26 Aug 2009 21:35:37 GMT https://community.qlik.com/t5/QlikView/Wildcard-normalization/m-p/167241#M38884 2009-08-26T21:35:37Z