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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

search and match TEXT and return what is leftover? 1
search and match TEXT and return what is leftover 1
How to search for specific Text in a field in Access and return what is between that? 2
Text Formatting of Expression Based Query Columns 0
How to modify a Word macro written for Windows so that will work on MAC 0
Excel Macro VBA to Count Google Search Results 0
How do I search a whole workbook using the =INDEX function? 3
Help with a partial match query 6

Top