Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Regex Help for parsing data in long string

chvizda
8 - Asteroid

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

 

2 REPLIES 2
PhilipMannering
15 - Aurora
15 - Aurora

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

 

 

hrefName="(.*?)"

 

Like so,

wfwf

 

 

 

chvizda
8 - Asteroid
Thx ! That's exactly what I need.
Labels