HELP PLEASE: Parse the Email address

[bwhaler]

Boy, do I need some help.

I receive in a text field an email header such as:

Name: N.Smith

TAG ID: EEN-0558

Email: [email protected]

Subject: General Question

For an email reply, I want to be able to automatically pull the email address out of the text field and set it to another field (the send address field for an email reply.)

Can anyone please show me how to parse out just the email address so I can populate it in another field.

THANK YOU SO MUCH IN ADVANCE FOR YOUR HELP. I'm under a terrible deadline, so thank you.

Bob

[CobaltSky]

Hi Bob,

Assuming that your header will always follow the same format, one way to achieve what you want would be via a formula along the lines of:

Let([

P1 = Position(HeaderField; "Email: "; 1; 1) + 7;

P2 = Position(HeaderField; ¶; P1; 1)];

Middle(HeaderField; P1; P2 - P1)

)

...where HeaderField is the text field in which your email header text is located. :o

[bwhaler]

You sir, are a god send.

Thank you so much for your help. If I were in Australia right now, I'd give ya a big hug. -)