Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

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

Remove everything outside four quotation marks in one string

mrbubi001
6 - Meteoroid

Hello i have the problem that i can't find a way to remove all the tags outside quotation marks. 

I have the following string:
<a href="https://adsecurity.org/?p=3299">https://adsecurity.org/?p=3299</a><br> <a href="https://attack.mitre.org/mitigations/M1047">[MITRE]Mitre Att&ck - Mitigation - Audit</a>

And what i want is only the urls so:

https://adsecurity.org/?p=3299 https://attack.mitre.org/mitigations/M1047

 

Thanks to whoever can help me!

1 REPLY 1
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @mrbubi001,

 

You could achieve this with a piece of Regex in tokenise mode:

 

 

a href="(.*?)">

 

 

JonathanSherman_0-1637143814638.png

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

 

Labels