ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Parse website out of string

lbolin
8 - Asteroid

I am wanting to parse out the website with is a string of data but leave other data alone.

For example:

 

OriginalParsed out

/biz_redir?url=http%3A%2F%2Fwww.uncletimsfoodtruck.com&cachebuster=1661896748&website_link_type=website&src_bizid=_3tyFt-G2ppSVIcRS86PCA&s=39567495988d1cd59560a14cf9607bb632eb94197fc1968b9d85565929d2880a

www.uncletimsfordtrck.com
https://www.yelp.com/biz/firehouse-subs-mobile-4www.yelp.com/biz/firehouse-subs-mobile-4
https://yelp.com/biz/agave-mexican-restaurant-mobile?osq=Restaurantsyelp.com/biz/agave-mexican-restaurant-mobile?osq=Restaurants

 

I don't know if regex can do this or if i need to do a combo of regex and other tools. 

2 REPLIES 2
dougperez
12 - Quasar

Hello!

I attached a workflow with two solutions, each one using Regex.

 

Alteryx_AR
12 - Quasar

@lbolin 

 

Attaching the solution here-

 

 

Labels
Top Solution Authors