RegEx to fetch values between html tags

[Adam_Mitchell]

I'm trying to sum up values that are held in a HTML string. I have many records, each with a string like below The values i want to sum up are in between the tags <value></value>. So i'd expect a column at the end to total up the figures in bold below (40,178.9)

<tprAAList><tpr><seqNo>1</seqNo><tprId>00132</tprId><effectiveDate>2022-10-01</effectiveDate><effectiveToDate>2023-03-06</effectiveToDate><value>4652.1</value></tpr><tpr><seqNo>2</seqNo><tprId>00206</tprId><effectiveDate>2022-10-01</effectiveDate><effectiveToDate>2023-03-06</effectiveToDate><value>10613.6</value></tpr><tpr><seqNo>3</seqNo><tprId>00230</tprId><effectiveDate>2022-10-01</effectiveDate><effectiveToDate>2023-03-06</effectiveToDate><value>23215.8</value></tpr><tpr><seqNo>4</seqNo><tprId>00249</tprId><effectiveDate>2022-10-01</effectiveDate><effectiveToDate>2023-03-06</effectiveToDate><value>801.0</value></tpr><tpr><seqNo>5</seqNo><tprId>00252</tprId><effectiveDate>2022-10-01</effectiveDate><effectiveToDate>2023-03-06</effectiveToDate><value>896.4</value></tpr></tprAAList>

[binu_acs · Accepted solution]

@Adam_Mitchell One way of doing this

[Qiu]

Sorry just find the solution is same as @binu_acs 

[Adam_Mitchell]

Great work! i was so close... i just didnt have the Regex set to tokenize. Thanks for the help