Thanks. This was helpful but only changed the first URL. My goal is to automate the creation of a a dynamic (growing) list of urls in a googlesheet. I am able to get the google search page results
I then connect a text parser to extract the links.
I then filter the results so I only get the 10 google results as opposed to the other google links that are found on the search results page.
I then save these results to a google sheet.
All of this works well, BUT the collected urls in the google sheet contain “/url?q=” at the beginning of the urls and also include “&” followed by other coding that is not part of the url.
I need to filter or replace the prefix /url?q= as well as the & and all text after the &.
I am assuming I can do this either before sending the urls to the google sheet or after but would appreciate further assistance.