I try to get the URL inside a < > (example, it is wrapped like this <www.apple.com>, and I would like to remove the < > to become a text of www.apple.com for sending to the next step.
I have already watched How to Use the Make SubString Function with 5 Example Use Cases. However, I still couldn’t get it.
Thanks in advance.
Hello! Welcome to the Make community!
There are multiple ways to do this. One relatively simple and straightforward is to use the replace function with a regular expression:
the regular expression here is /<|>/g
Which means < OR > and search globally
Regards,
Benjamin
Thanks Benjamin, it works!
Thanks for solving my last issue, Benjamin!
I now have a new URL wanted to grab, I got the link from google alert, and it is like this:
Example 1:
Example 2:
Where you can see, it is wrapped with ht tps://www.google.com/url?rct=j&sa=t&url
and
ended with
&ct=ga&cd=CAIyGmMyOGMwZDZjNTUyYmZiZTg6Y29tOmVuOlVT&usg=AOvVaw3jX4Rt9A9IBISYDKnR8W-f
however, the ending part are always radom each time, may I know how to replace/remove them so I can just get the link in between all the time?
Thanks in advance.
Hi @Eric_Leung
To extract the URL from the link, you can use a regex expression to capture the text between “&url=” and “&cd=”. The following regex will do:
(?<=&url=).*?(?=&cd=)
We have tested with one of the link you provided.
Output:
If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support| Book Live Implementation
Visit us here
Youtube Channel
Thanks MSquare, it works very well. Thanks again!
