Jump to content

HELP PLEASE: Parse the Email address


bwhaler
 Share

This topic is 5639 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 5639 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.