Mid function ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have data stored in a field with this data:
QT,HV2/883627,CPU NOT SEATED

The format is not the same all the time but the data is relatively the same.
I really only need to extract the loc/number data. The loc info will range
from 3 to 5 characters ending in a number. The number field will always be
6. They may or may not be in the loc/number format. How do I pull that data
out?
 
Does the 'loc' always begin after the first comma? Does the 'number' always
begin after the first '/'?
 
If you can use the comma (,) then you can try

left(mid([FieldName],instr([FieldName],",")+1),instr(mid([FieldName],instr([FieldName],",")+1),",")-1)
 

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

how to sum values in multiple fields and put in another 3
Using Access query data lookup values 1
Insert Row also adds formulas and moves cursor 2
Number Range Query 8
Extracting data from strings 9
Problem on multiple table query. 1
Count based on multiple fields 4
problem opening file thru code 2

Back
Top