Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Where Len(KeepChar(Left(Lower(FieldName), 4), 'abcdefghijklmnopqrstuvwxyz')) = 4 and Mid(FieldName, 5, 1) = '-';
May be this
Where Len(KeepChar(Left(Lower(FieldName), 4), 'abcdefghijklmnopqrstuvwxyz')) = 4 and Mid(FieldName, 5, 1) = '-';
Thank you so much Sunny that worked perfectly!
Have a great day.