Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Load data only where field contains specific text

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

Labels (5)
1 Solution

Accepted Solutions
Highlighted

Re: Load data only where field contains specific text

May be this

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

View solution in original post

2 Replies
Highlighted

Re: Load data only where field contains specific text

May be this

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

View solution in original post

Highlighted
Contributor
Contributor

Re: Load data only where field contains specific text

Thank you so much Sunny that worked perfectly!

Have a great day.