how can I sepreate infor. from one field to new fileds?

[william liang via AccessMonster.com]

I am try to pick out email address from one field and put into another
field since email is mixed out in that field. It looks like this:

"ffffffdfer my****@yahoo.com" I am trying to pick "my*****@yahoo.com" out
and put in a seperate field.

Can anybody help me with this?

Thanks

--
Message posted via http://www.accessmonster.com

[Chuck]

On Fri, 22 Apr 2005 20:27:30 GMT, "william liang via AccessMonster.com"
<fo***@nospam.AccessMonster.com> wrote:

Depending on how and where you are going to use the email address, you may not
have to generate a new field in a table. I don't like to add a field to a
table that already has the infromation you want in an existing field.

If the mixed out field has only one space and that space is in front of the
email address, then:

You can make a query that contains the field with the mixed out email, plus any
other fields you may want. In the FIELD row of a blank column in the query
enter EmailAddress:Mid([A],(instr([A]," ")+1),(len([A])-(instr([A]," "))))
where A is the name of the field with the mixed email. Note the space between
the double quotes. This new column will have only the email address.

Chuck Libbey
---

I am try to pick out email address from one field and put into another
field since email is mixed out in that field. It looks like this:

"ffffffdfer my****@yahoo.com" I am trying to pick "my*****@yahoo.com" out
and put in a seperate field.

Can anybody help me with this?

Thanks