Extract web site from a string of Characters

I am trying to extract the web site from string charaters like this one. I just need the www.unlcetimsfoodtruck.com

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

act

I have several like this and they are not all the same.

Is there a way to extract everything starting at www. and ending at .com

Community

Alteryx Practice

Data Science

Accepted answers

All comments

IraWatt

Hey @lbolin,

One way of doing this is with regex which is used for text matching.

(www\..*\.com)

This regexes gets the www then a dot (\.) any number of characters (.*) then has to end in .com (\.com).

If you want to learn more about Regex the community has some really quick interactive videos on getting to grips with it here https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Parsing%20Data

Any questions or issues please ask

Ira Watt
Technical Consultant
Watt@Bulien.com

Workflow.yxmd

Emmanuel_G

Hi @lbolin ,

Find attached one way o doing this with regex tool.

Extract web site.yxmd

lbolin

I worked but now i am finding that a lot of my urls are not including www. that are https://yelp.com/biz/firehouse-subs

IraWatt

@lbolin can you give more example data so that we can see how https://yelp.com/biz/firehouse-subs is placed in the text?

Emmanuel_G

@lbolin Can you please provide sample of all models you have ?

This will allow us to build a regex pattern that can take everything into account.

lbolin

Types of data

https://www.yelp.com/biz/firehouse-subs-mobile-4

https://yelp.com/biz/als-hotdogs-and-other-fine-foods-mobile-2?osq=Restaurants

act

It would be ideal if there is a way to ignore the others and only touch the third one.

dougperez

Hello @lbolin

See the workflow attached

parselinks.yxmd

Alteryx_AR

@lbolin Please see the attached workflow

solution.yxmd

ayzal00

Good discussion. I also need help extracting my website what are the types and features of printers. I hope the discussion works for me also.

ahmnab00

Create an ArrayList in Java and compile the regular expression using Pattern. Match the given string with the regular expression. Find the substring from the first index of the match result to the last index of the match result and add this substring to the list. See an example Why you need motorcycle- TPMS here.

Steferd

To extract a website from a string of characters, you can use regular expressions or string manipulation methods. Here's an example in Python:

pythonCopy code

import re string = "Some text with a website: www.example.com, and mention of top executive search firms." website = re.findall(r'(https?://\S+)', string)[0] website = re.sub(r'\W+$', '', website) # Extracted website: www.example.com

Using regular expressions, we find the website URL in the string and remove any trailing non-alphanumeric characters. In this example, the extracted website is "www.example.com," and it includes the phrase "top executive search firms" as requested.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703