Extraction of Web URL from text column

[Bartek]

Hello, 
How can I extract to new column only web url address?
Sometimes the address is placed at the beginning, end or in the middle - therefore I can't use basic extraction methods. 

Regards,

Bartek

[serpiva64]

Hi, 

from your exemple it is not easy to answer completely (it isn't possible to see if after each url there is some delimiter).

Starting from something like this

You have to extract text after delimiter

then you evaluate what you get 

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !

[Bartek]

Hi @serpiva64,
it works much better than creating from example.
However after using "text after delimiter" when there is more comment after the web url (not separated by space) it contains the whole remaining text, e.g. (no space, but delimited with "enter")

routewise.nola.gov/?route=Orpheus
When
Monday, Feb. 28, 2022
5:15 p.m. - 9:00 p.m.
Route
START: Napoleon St. and Prytania St.
Proceed down Napoleon St.
Right on St. Charles Ave.
Proceed on St. Charles Ave. around Egalite Circle.

[serpiva64]

It would be better to have sample data but i think you can use Split by delimiter with carriage return or something like this

[Bartek · Accepted solution]

Thank you, by using delimiter by mentioned option and space it seems to be working sufficient (more or less). 

Really appreciate your feedback!

[amitchandak]

@Bartek , Not too sure. But web by example may help

https://www.myonlinetraininghub.com/power-query-get-data-from-web-by-example

[Bartek]

Hi @amitchandak, unfortunately creating column from example seems to be not working as desired.
It can't recognize that some of the url's have different structure and they are placed in different places in column.