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