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
Solved! Go to Solution.
Yes. You can parse using the Regex tool and use this pattern,
hrefName="(.*?)"
Like so,