Parsing Query field based upon a character

[jgabel]

I have a field called "F1", below is an example of what one of the rows looks like.

In MS Access query I want to parse out field "F1" into 2 different columns in my MS Access query. Column 1 the email name, the field is divided by the left and right arrows. Column 2 everything before the left arrow

CURRENTLY F1 SHOWN AS EXAMPLE: Note I actually have @ in the email as I could not post an actual test email address
Test, Nicole :Waterloo Clinics <NTESTatTEST.com>

WANT COLUMN 1:
NTESTatTEST.com without the left and right arrows

WANT COLUMN 2:
PARSE 2: (everything before the email address) like
Test, Nicole :Waterloo Clinics

 

[jdraw]

Try this query

SELECT F1,
Mid([F1],InStr([F1],"<")+1,InStr([F1],">")-1-InStr([F1],"<")) AS Parse1
, Trim(Mid([F1],1,InStr([F1],"<")-1)) AS Parse2
FROM YourTableName;

 

[jgabel]

Worked great, thank you so much for your help!!!