Finding wildcards with instr? (1 Viewer)

[wackywoo105]

I'm trying to find a sting like "AFE43542" within a web page html with instr. The string will always be of the format [a-z][a-z][a-z]#####.

I've used

"[a-z][a-z][a-z]#####"

and

"???#####"

Istr never finds the match.

What am I doing wrong?

 

[Mike Krailo]

Maybe look into regular expressions HERE.

[a-zA-Z][a-zA-Z][a-zA-Z][0-9][0-9][0-9][0-9][0-9]

 

[theDBguy]

Not sure that InStr() is capable of using wildcards.

InStr function (Visual Basic for Applications)

Office VBA reference topic

learn.microsoft.com

You might try using the Like operator instead.

Like operator

Office VBA reference topic

learn.microsoft.com

 

[wackywoo105]

Thanks. I knew I was having another brain freeze moment

Me.EdgeBrowser0.RetrieveJavascriptValue("document.documentElement.innerHTML") Like "*[a-z][a-z][a-z]#####*"