Regular Expression for HTML

Question

From this string:

<strong class="big zindex-pt zindex-pt-all">&pound;2,362,214</strong>

I am trying to get £2,362,214 using this Regex in Excel VBA:

 .Pattern = "<strong class="big zindex-pt zindex-pt-all">([\s\S]*?)<"

Any ideas what I am doing wrong?

Well, for one thing you're parsing HTML with regular expressions. — danielmhanover
– danielmhanover, Commented Jun 16, 2015 at 23:19

Jahid · Accepted Answer · 2015-06-16 23:29:12Z

1

Escape double quotes inside regex: " to ""

answered Jun 16, 2015 at 23:10

Jahid

22.6k10 gold badges97 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

there are a lot of other html lines that I didn't mention in the question.. I need to target this line specifically.

I am actually getting compile errors in Excel VBA. Somehow I need to exit the quotemarks in my Pattern ?

In VBA " is escaped with "" (doubled-up quotes)

Brian Tompsett - 汤莱恩 · Accepted Answer · 2015-06-25 14:45:09Z

0

ok thanks. Actually this works for me:

.Pattern = "<strong class=""big zindex-pt zindex-pt-all"">([\s\S]*?)<"

5,92772 gold badges63 silver badges135 bronze badges

answered Jun 16, 2015 at 23:22

JoaMika

1,83710 gold badges36 silver badges69 bronze badges

\S matches anything that is not \s and both of them combined matches anything at all