Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a way to check the string if it is preceded by a number?
For example:
String = "1234 abcdefg"
Wildmatch(String,'*# abcd*') > 0
Try to use like
String = "1234 abcdefg"
=WildMatch(String, '*abcd*')
=If(IsNum(Left('1234 abcdefg',1)),'Num','Not Num')
=If(IsNum(SubField('1234 abcdefg',' ',1)),'Num','Not Num')
I Used Wildmatch(String, '?????abcd*') > 0 instead.
This expr returns true even if you have alphabets
Wildmatch('abcd abcd', '?????abcd*') > 0