Repost: Parsing data into multiple fields

  • Thread starter Thread starter Avid Reader
  • Start date Start date
A

Avid Reader

The left function works fine but the Right and Mid functions not so good.

The Mid function returns #Error and the Right function is hit and miss.
Sometimes it pulls all the way back to the "\" and sometimes it includes the
backslash.

Any other ideas on the correct formula. I think what John has given me is
real close but not quite. Thanks everyone.
 
Thanks John it worked great. Here are the correct formulas that I used. I
hope this helps someone else out there.

Left: Left([MyField],InStr([MyField],"\")-1)
Mid:
Left(Mid([MyField],InStr(1,[MyField],"\")+1),InStr(1,Mid([MyField],InStr(1,[
MyField],"\")+1),"\")-1)
Right: Mid([MyField],InStrRev([MyField],"\")+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

Split data in field on character return 0
Parsing inconsistent data 6
Parsing Names 6
Parsing Text Field In Access and using NZ 1
parse some text from an inconsistent text field 6
Parsing data into multiple fields 4
Parsing name into correct fields 3
parse data from text field 3

Back
Top