I am new to Make and hope someone can provide some assistance.
I need to createa scenario where a google search result will populate a google sheets page with urls from the search results.
I have successfully done this by using a HTTP module (gets the google search results url) then a text parsing module (extracts the links from the data) and then a Google Sheets module (to save the filtered urls) BUT the 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 &
For more information, see Text Parser in the Make Help Center:
Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps! Let me know if there are any further questions or issues.
Thanks. That helps. I ran it and it removed the exact single instance. How there are multiple results in the google search so how would I modify this so that it does the same for all urls when the urls are all different?
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
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.
I don’t see the replace function with the regex pattern I provided to you used anywhere in your screenshots.
Did you know, this forum has a Hire a Pro category, where you can post your request for off-site specialised help on other platforms (video call/screenshare/private messaging/etc.)? This may help you get your issue resolved faster especially if it is urgent. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services (even offer FREE assistance to help) in other categories like here. Once you have posted in the Hire a Pro category, that will allow other members like me to provide booking links to our calendars for a free consultation and video assistance (including screenshare)!
