community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Extract URL's from string

Asteroid

2018.3.5.52487

Alteryx Partner

Try this one!

Asteroid

Hi not really what I need - I want to get 1 extra column, with the 2 URL's separated by a comma.  Some of the data has up to 9 URL's in that one section

Alteryx Partner

If you want to Concat the URL's, following workflow might be a solution.

Alteryx Certified Partner
Alteryx Certified Partner

you can do a regex replace with this formula -> href="(.+)" .+ href="(.+)" .+  then add them fith a formula tool

[regex_replace1] + " ," + [regex_replace2]

 

as long as there are more https keep adding more

Asteroid

Will give the above a try in a minute but just now I have a very dirty solution!

 

"(.*?)" in the regex tool, then run a regex_replace to remove "_Blank" and replace with nothing, then another regex_replace to remove " and replace them with nothing

Labels