Extract one string from another

  • Thread starter Thread starter Leslie Isaacs
  • Start date Start date
L

Leslie Isaacs

Hello

Is it possible to extract one string from another - so for e.g. if stringA =
"This is a string" and stringB = "is a" then the expression to extract
stingB from StringA should return "This string".

I would be very grateful if anyone could help me with this.

Many thanks
Leslie Isaacs
 
Use Replace function in later versions of Access.

In earlier versions, 97 and some of 2000, you'll need to write a VBA
function or use instr, len, mid functions to do this.
 

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

passing values from form to module 5
best deal with value pairs that contain duplicates 7
Excel Extract Text from decimal separated string 6
extract 3 numbers from a string 0
Extracting data from string 5
Question about an old operator 6
attn: regex gurus. can this be done with a regular expression or using a different technique? 5
Extract a text between two last parentheses 3

Back
Top