search and match TEXT and return what is leftover

  • Thread starter robertadamharper
  • Start date
R

robertadamharper

Hi
I have a list of text values within a field in access and I want to
return the text that appears to the left of that it the field value
matches specific text?
eg.

Value
"www.google.co.uk/search?hl=en&q=hazard signs&meta="

if the value matches "search?hl=en&q" return what is to the left of
that up until the "&meta="

Answer
Would return "=hazard signs"

Many Thanks
 
Top