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)
 
Back
Top