Extract URL using formula
Hi, Could I get some guidance on how to use formula to extract a URL from text field ? ------------------------------ Prashant Maheshwari ------------------------------
Forum Discussion
Hi Ahuva
There are other content in this text Field as well .
------------------------------
Prashant Maheshwari
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou will need to give us examples of the data to look for patterns
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Hi guys ,
some example of URL
https://www.trebound.com/virtual-team-building
https://www.linkedin.com/pulse/mistake-lack-pride-sameer-kamboj
https://blog.albertarmea.com/post/91024308173/losslessly-splitting-videos-by-chapter-using-bash-and
https://blog.ipleaders.in/vishaka-guidelines/
https://www.vice.com/en/article/jg8wq7/slovenia-car-free-city-ljubljana
I was trying to play with items which start with https and capture till space comes but unable to capture it all.
------------------------------
Prashant Maheshwari
------------------------------- MarkShnier__YouAre you looking to populate say 10 fields with the first 10 URLs?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Thanks for reply Mark, just 1 single URL
------------------------------
Prashant Maheshwari
------------------------------
- I managed to make this workwith this formula (in the extract url field): "www"& Left(Right([text field],"www")," ")
I ran into a problem when the URL included https, because writing the formula like this did not work:
"https"& Left(Right([text field],"https")," "), but maybe you can play around with it.
------------------------------
Ahuva Brown
------------------------------- Thank you Ahuva for your solution ! This is taking care of www part , I'm able to extract items
@Mark Shnier Help for HTTP/HTTPS extraction would be appreciated.
Some example of the data record are as below. In ALL cases they are 1 single URL with a note inside which during capture , I've mentioned why I should look at the URL.
1. Note to self , check team building by TreBound they are doing fine https://www.trebound.com/virtual-team-building
2. https://www.linkedin.com/pulse/mistake-lack-pride-sameer-kamboj Read the article by Sameer ji , this can give some insights into the course
3.This article gives clear instructions, check if we can automate something on MacMini using Keyboard Maestro , assign to Rasika https://blog.albertarmea.com/post/91024308173/losslessly-splitting-videos-by-chapter-using-bash-and
4. https://blog.ipleaders.in/vishaka-guidelines/ These guidelines have been given by the lawyer, they have to be studied and implemented into the workplace as soon as possible, have a chat with the HR who can look at existing policies and see if they can be merged
------------------------------
Prashant Maheshwari
------------------------------
