By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,663 Members | 2,152 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,663 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.