Forum Discussion
Extraction of Web URL from text column
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
Thank you, by using delimiter by mentioned option and space it seems to be working sufficient (more or less).
Really appreciate your feedback!
6 Replies
- amitchandak
Super User
Bartek , Not too sure. But web by example may help
https://www.myonlinetraininghub.com/power-query-get-data-from-web-by-example
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.
- serpiva64
Solution Sage
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 !
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
