Alteryx Designer Desktop Discussions

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

Regex - replace text

cmcclellan
13 - Pulsar

I can usually figure out REGEX_REPLACE syntax, but this one has me stumped 😞 

 

I have these values in the field:

 

          <a href="/blah/test">Test 123
          <a href="/blah/more text">Description goes here
          <a href="/blah/value 1">Value 1, <a href="/blah/Value X">Value No 2

 

I need to remove the A tag HTML and keep the rest, so make it:

 

          Test 123
          Description goes here
          Value 1, Value No 2

 

I want to do this in a REGEX_REPLACE if possible, but I can't get it to recognise the < and the >

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus

<.*?>

you should be able to replace this with '' and get rid of the tags. 

cheers,

 

mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
cmcclellan
13 - Pulsar

Perfect 🙂 

 

Thanks mate, I was coming back to post what I'd finally figured out would work, but your solution is a lot more elegant and understandable 🙂 

Labels