topic Re: Wildmatch Function in QlikView

Wildmatch Function

Fri, 20 Feb 2015 03:13:29 GMT

Is there a way to check the string if it is preceded by a number?

For example:

String = "1234 abcdefg"

Wildmatch(String,'*# abcd*') > 0

senpradip007 — Fri, 20 Feb 2015 04:08:55 GMT

Try to use like

String = "1234 abcdefg"

=WildMatch(String, '*abcd*')

anbu1984 — Fri, 20 Feb 2015 05:14:01 GMT

=If(IsNum(Left('1234 abcdefg',1)),'Num','Not Num')

=If(IsNum(SubField('1234 abcdefg',' ',1)),'Num','Not Num')

Fri, 20 Feb 2015 05:24:03 GMT

I Used Wildmatch(String, '?????abcd*') > 0 instead.

anbu1984 — Fri, 20 Feb 2015 05:31:25 GMT

This expr returns true even if you have alphabets

Wildmatch('abcd abcd', '?????abcd*') > 0