View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris W. Chris W. is offline
external usenet poster
 
Posts: 10
Default Like Operator vs Regular Expressions

I am trying to find out if there is anyway to simulate the
functionality of the Reular Expression's "*" when using
the Like operator. specifically: in Regular expressions
the "*" refers to Multiple Occurences, so, [\w]* mmeans
any multiple occurence of a word character,Equivalent to
[a-zA-Z0-9]. But with the Like operator "*" means "Any"
multiple characters, which includes the whole ASCII
character set. Is there a way to limit it to just
MULTIPLE characters that are just alpha-numeric.