Find text within field

  • Thread starter Thread starter ChrisR
  • Start date Start date
C

ChrisR

Trying to do something in Access that I usually do on smaller recordset in
Excel. Want to search a field for a string then have access return the
point at which the searched string starts. That way I can do a mid
functions to try to strip the string and trailing characters into a new
field.

In Excel it is as simple as =find("Unit of measure:",A1) and what is
returned is 12 which represents how many characters in the string "Unit of
Measure:" starts. That way I can find that string and get the say first 5
characters after it finishes.

Not having any luck doing the same operations in an Access query. Any help
would be greatly appreciated.

c-
 

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

Replace or insert characters in text string 6
Parse text string and insert characters 5
Delete Specific Characters From Text 1
Top n query using Allen Browne's "ConcatRelated" 3
MSACCESS 97 APPLICATION ERROR CONVERTING FROM TEXT TO MEMO 4
Parse String within Query 2
problem with "#" 6
Text replacement calculation returning error values 2

Back
Top