Wildcard in Instr?

  • Thread starter Thread starter mcl
  • Start date Start date
M

mcl

Is it possible to use single charcater wildcards in "InStr"?
In this case I wanted to search for a "/" preceeded and followed by 2
numerical characters but it didn't work.
May I assume it can't be done or did I just use the wrong syntax?

This is what I used. I was able to search for just a "/" but when I added
the #'s it was a no go.
InStr([Remark],"##/##")
 
Instr() doesn't support wildcards. Check out VBA's Like operator

bolResult = [Remark] Like "*##/##*"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use of Wildcard in String Expression 4
Tricky Wildcard 2
INSTR 4
Instr parsing with a comma delimited string 3
Excel Wildcard in Excel array formula 0
Help with InStr function 3
c# version of InStr? 1
Multiple wildcard criteria 2

Back
Top