Repost: Parsing data into multiple fields

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.
 
J

John Spencer (MVP)

See my response to your earlier post. I apologize for the faulty functions.
 
A

Avid Reader

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