Filter values

[Aika]

Hi,

I have values, in a column date, like:

043689#PENLS_298610
000329#PEN_359677
000450#PEN_632580
096574#PENLS_156436
084405#PENLS_290274
...

I need to clean up the column date and get only the values that have "PENLS" inside:

043689#PENLS_298610
096574#PENLS_156436
084405#PENLS_290274
...

How can I do this using a Qlik function?
Who can help me in a short time?

[MayilVahanan]

Hi

Try like below

If(wildmatch(columndatafield, '*Penls*),columndatafield, '') as columndatafield

[Aika]

Thank you, I try.