Conjunction of Re: Search/Trim from Memo Field

Thanks Greg for the additional tips, actually it's 99% done. I used only the Left, Mid and one Counter and its working except for
recognizing the Enter as a Space.

What I mean is, if the email address is between two spaces it is fine: eg.
MyMemoValue: "This is a test, george@c... should be the correct email not georgeoro@y... address."
Return=george@c...

But if after the email address is a new line (by pressing enter)it doesn't recognized the new line as a space.
MyMemoValue: "This is a test, george@c...
should be the correct email not georgeoro@y... address."
Return=george@c... should

Any tips would be highly appreciated...

TIA,
George




> -----Original Message-----
> From: Gregory Serrano [mailto:SerranoG@m...]
> Sent: Thursday, March 13, 2003 1:59 PM
> To: Access
> Subject: [access] Re: URGENT: Search/Trim from Memo Field
>
>
> George,
>
> << Unfortunately I have a new requirements which I tried to figure it out
> and no success. Basically there some cases that the email
> address is not mid of [ ] and it can found any of the line.
>
> For instance this is my strMemo:
> "This is my test to search email address anywhere george@c... then
> save to the database." >>
>
> Unfortunately, the only thing you can look for there is the "@" symbol.
> You can use the INSTR and MID functions to first locate the "@" then to
> locate the " " (space) before the "@" and the one after.  The e-mail
> address is then = the string between the two " ".  The only problem with
> this is that if someone enters the "@" sign for any other reason, you're
> doomed!   :)
>
> Greg
>