I have an RSS feed from a google alert that lists URLs of interesting posts I want to post to a LinkedIn page..
The RSS feed prepends and appends elements to the actual URL of the article found.
Here is an example of the URLs in the RSS feed item link:
https://www.google.com/url?rct=j&sa=t&url=https://uk.news.yahoo.com/sony-drive-electric-car-using-122631827.html&ct=ga&cd=CAIyHDNhNjhjNTg3NzhjZWM2NjI6Y29tOmVuOkdCOlI&usg=AOvVaw3Y112e8T6E2w9ERxzkXL-h
I need to remove the prepended data which is this part https://www.google.com/url?rct=j&sa=t&url=
And to remove the appended data which is this part and anything following &ct=ga&cd=
which is a random unique string of letters and numbers &ct=ga&cd=
so I want to be left with the bare URL of the post…
which in the above example would be the part
https://uk.news.yahoo.com/sony-drive-electric-car-using-122631827.html
Then the Zap post that to a new page post on LinkedIn with the Title and Description from the post.
How can I extract the URL in the RSS, tried using regex and format changer but its not working...