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?