Extract Text

[mchadwick]

I have an email address that contains a LANID "Jones, Bob (bjones@domain1.com)". I would like to extract the "bjones" out of the field and put it into another field by itself in another field in the same record.

Field 1
Name
Jones, Bob (bjones@domain1.com)

Field 2
LANID


bjones

The information I want to extract (or text) is always the same, between the "(" and the "@". What can I do in a query?

[pbaldy]

You can combine the InStr() function with the Mid() function and some creativity to peel out that portion.