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
 
					
				
		
 senpradip007
		
			senpradip007
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		Try to use like
String = "1234 abcdefg"
=WildMatch(String, '*abcd*')
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		=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.
 anbu1984
		
			anbu1984
		
		
		
		
		
		
		
		
	
			
		
		
			
					
		This expr returns true even if you have alphabets
Wildmatch('abcd abcd', '?????abcd*') > 0
