https://community.qlik.com/t5/QlikView/Filter-values/m-p/1823366#M1213774 <P>Hi,</P><P>I have values, in a column date, like:<BR /><BR />043689#PENLS_298610<BR />000329#PEN_359677<BR />000450#PEN_632580<BR />096574#PENLS_156436<BR />084405#PENLS_290274<BR />...<BR /><BR />I need to clean up the column date and get only the values that have "PENLS" inside:<BR /><BR />043689#PENLS_298610<BR />096574#PENLS_156436<BR />084405#PENLS_290274<BR />...<BR /><BR />How can I do this using a Qlik function?<BR />Who can help me in a short time?<BR /><BR /></P> Tue, 20 Jul 2021 19:21:09 GMT Aika 2021-07-20T19:21:09Z https://community.qlik.com/t5/QlikView/Filter-values/m-p/1823366#M1213774 <P>Hi,</P><P>I have values, in a column date, like:<BR /><BR />043689#PENLS_298610<BR />000329#PEN_359677<BR />000450#PEN_632580<BR />096574#PENLS_156436<BR />084405#PENLS_290274<BR />...<BR /><BR />I need to clean up the column date and get only the values that have "PENLS" inside:<BR /><BR />043689#PENLS_298610<BR />096574#PENLS_156436<BR />084405#PENLS_290274<BR />...<BR /><BR />How can I do this using a Qlik function?<BR />Who can help me in a short time?<BR /><BR /></P> Tue, 20 Jul 2021 19:21:09 GMT https://community.qlik.com/t5/QlikView/Filter-values/m-p/1823366#M1213774 Aika 2021-07-20T19:21:09Z https://community.qlik.com/t5/QlikView/Filter-values/m-p/1823529#M1213782 <P>Hi</P><P>Try like below</P><P>If(wildmatch(columndatafield, '*Penls*),columndatafield, '') as&nbsp;columndatafield</P> Wed, 21 Jul 2021 08:32:30 GMT https://community.qlik.com/t5/QlikView/Filter-values/m-p/1823529#M1213782 MayilVahanan 2021-07-21T08:32:30Z https://community.qlik.com/t5/QlikView/Filter-values/m-p/1824782#M1213872 <P>Thank you, I try.</P> Tue, 27 Jul 2021 10:47:28 GMT https://community.qlik.com/t5/QlikView/Filter-values/m-p/1824782#M1213872 Aika 2021-07-27T10:47:28Z