Regex Help for parsing data in long string

[chvizda]

Hi all

I have a dataset with several xml fields which look lijke this:

<routingpolicy><link href="https://test.com/NRP/admin/routingpolicies/327680" hrefName="PSTN_International_Calls_over_P1_UH" rel="reference" title="BT One Voice U"/></routingpolicy>

<sipdomain><link href="https://test.com/NRP/admin/domains/163842" hrefName="test.com" rel="reference" title=""/></sipdomain>

The structure is different but I need to parse everytime the data within the " " behind the hrefName= marked in fat above.

Is there an easy way to extract these data into a new field ?

Many thanks for your support

Steffen

[PhilipMannering · Accepted solution]

Yes. You can parse using the Regex tool and use this pattern,

hrefName="(.*?)"

Like so,

wf

[chvizda]

Thx ! That's exactly what I need.