topic Re: Recode in script in QlikView https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695579#M1082986 <HTML><HEAD></HEAD><BODY><P>IF(WildMatch(Field,'*DB*),Field) as Field</P></BODY></HTML> Tue, 17 Jun 2014 15:32:42 GMT MK_QSL 2014-06-17T15:32:42Z Recode in script https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695578#M1082985 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>I have field which has string value DB or DBNull and numbers.</P><P>I'd like to recode them in system missing.</P><P>I tried to use </P><P>IF(wildmatch(Field, '*DB*', ''), Field ) as Field</P><P>It didn't work.</P></BODY></HTML> Tue, 17 Jun 2014 15:31:17 GMT https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695578#M1082985 Anonymous 2014-06-17T15:31:17Z Re: Recode in script https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695579#M1082986 <HTML><HEAD></HEAD><BODY><P>IF(WildMatch(Field,'*DB*),Field) as Field</P></BODY></HTML> Tue, 17 Jun 2014 15:32:42 GMT https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695579#M1082986 MK_QSL 2014-06-17T15:32:42Z Re: Recode in script https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695580#M1082987 <HTML><HEAD></HEAD><BODY><P>Try with this</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">IF(wildmatch(Field, '*DB*'),'',Field ) as Field</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">If found what you need blank space or some other value.<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Tue, 17 Jun 2014 15:35:26 GMT https://community.qlik.com/t5/QlikView/Recode-in-script/m-p/695580#M1082987 its_anandrjs 2014-06-17T15:35:26Z