Wildcard in Instr?

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],"##/##")
 
G

George Nicholson

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

Tricky Wildcard 2
INSTR 4
Use of Wildcard in String Expression 4
Help with InStr function 3
c# version of InStr? 1
Wildcard in the InStr command 3
Excel Wildcard in Excel array formula 0
Find start position of the 9th occurance of a <character> in a str 2

Top