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