Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop 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
16 - Nebula
16 - Nebula

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