Brain Fade.....

[M Rosales]

Text functions are not my forte and any help would be appreciated

What I have done is create a mailbox for my contact manager. When I download the mail from the server I will automatically relate the message with a contact if it matches any of the contact email addresses.

The problem is I am having difficulty extracting just the email address from the senders complete name eg: "Joe Smith" <Joe.smith@@nowhere.com>.

The common factor with all emails would be < > I need to extract the address without regards to content size within.

Any suggestions.....

[Søren Dyhr]

Try this

Let([theStart =

Position ( headertext ; "<" ; 1 ; 1 ); theEnd = Position ( headertext ; ">" ; 1 ; 1 )];

Replace ( Replace ( headertext ; TheEnd ; 99999999 ; "" ) ; 1 ; theStart ; "" ))

--sd

[M Rosales]

Thanks for your help S