topic Load data only where field contains specific text in QlikView

Load data only where field contains specific text

davidthorpester — Sat, 16 Nov 2024 21:09:37 GMT

Hi There,

I am trying to load some data into QV where the field has:

The first 4 characters are a letter (a-z) AND the fifth character is a -

How would I write a WHERE statement in QV to extract this?

Thanks very much, David

sunny_talwar — Thu, 28 Mar 2019 16:30:00 GMT

May be this

Where Len(KeepChar(Left(Lower(FieldName), 4), 'abcdefghijklmnopqrstuvwxyz')) = 4 and Mid(FieldName, 5, 1) = '-';

davidthorpester — Thu, 28 Mar 2019 18:51:10 GMT

Thank you so much Sunny that worked perfectly!

Have a great day.