Convering email info into table

[Ana]

Hi,
I have a long email list (about 9900) which I'd like to convert into a table
(now empty) having the following columns:

EMAIL_ID (autonumber)
EMAIL_NAME
EMAIL

the list is text formatted as:

"A.T.E.S.E." <[email protected]>,
"A.V.R. RACING" <[email protected]>, etc.

Howto strip the extra caracters and move the info into the table?
TIA
Ana

Access XP

 

[John Vinson]

Hi,
I have a long email list (about 9900) which I'd like to convert into a table
(now empty) having the following columns:

EMAIL_ID (autonumber)
EMAIL_NAME
EMAIL

the list is text formatted as:

"A.T.E.S.E." <[email protected]>,
"A.V.R. RACING" <[email protected]>, etc.

Howto strip the extra caracters and move the info into the table?

You can use the string handling functions Left(), Mid(), and InStr. Link to
your list (or import it); let's say this single field is named FullEMail. you
can run an Append query to your new table, appending:

Left([FullEmail], InStr([FullEmail], "<") - 1)

to EMailName, and

Mid([FullEmail], InStr([FullEmail], "<") + 1, InStr([FullEmail], ">") + 1)

to EMail.

John W. Vinson/MVP