Hi All ,
Here is an example below :
https://www.google.com/search/?text=alteryx + Designer + version&rlz=1C1GGRV_enUS751US751&oq=alteryx&aqs=chrome..69i57j69i59j69i60l2j69i59j69i60.1399j0j7&sourceid=chrome&ie=UTF-8
I want to extract the search key words from the URL
so I should extract the following:
All the URL will contain "search/?text=" before the keywords , multiple keywords separated by + but the content after the keywords can change and there is no pattern to it.
Thanks
Solved! Go to Solution.
Hi @saivig68,
Here is a "simple" approach. What I see is the following:
I used a formula tool & created a field [URL Parsed] as a string with this formula:
REGEX_Replace([URL], ".*?text=(.*?)\&.*", '$1')
That finds the "good stuff" sandwiched between boring stuff and more boring stuff.
Then I updated the "good stuff to make parsing simple:
REGEX_Replace([URL Parsed], "\s*\+\s*", '|')
I used the regex expression to find zero, one or more spaces followed by one + sign followed by zero, one or more spaces.
Now you can readily extract and play with your terms.
Cheers,
Mark
Thanks @MarqueeCrew , the solution works for multiple keywords and parses everything for single term URL