ACCESS Multi-trim

[chexsp]

I am in need of help.

I need to trim multiple strings from a field in a Access database table.
ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88"

How would I just extract "MARK" using the proper SQL statement?

 

[luceze]

If the string is consistent with the above example then this should work:

=Mid([test],InStr([test],"NAME=")+5,InStr([test],";")-(InStr([test],"NAME=")+5))

Just change [test] to your field name.

HTH,
Eric

 

[RoyVidar]

Forgot to post here too, crossposted thread702-800532.

Roy-Vidar