Need to extract the email id form one para.

[vinod22kv]

Hi ,

I am trying to extract the email id from the cell. mark data is givn bellow.

My requreiement is if From field=website@vinod.ie

then i have to pick the email id from  body field and body field has somany strings.

Can you please help me out.

From	Body
ahevahebv@gmail.com	;kjengne
akjefv@escapes.ie	aedfhdn
lvafv@gmail.com	sghs
website@vinod.ie	a'jvfaej ajnjnakv; ajf kjae Emailjaeghf@gmail.com
website@vinod.ie	uihdv iuerhgvjn sdkjfhisuetr kjadvuhg <aehjanfdvj@yahoo.com>
afv@escapes.ie	gaevz
dfa@hotmail.com	zvzva

[isingh30]

I am not sure about this. Did you try subfield function?

Thank you!

[datanibbler]

Hi,

so, if I understand it correctly, many times the body_field does not contain anything usable - you just have to find out whether there is an email id and extract it if there is.

If so, then I suggest going in several steps:

- First you should look for the @ sign using the INDEX function. => only where you find that, there is an email at all, so you should filter out just those records for further processing.

- Then you have to find both ends of the string:

-- The back end is easy - it is either ".de" or ".com" or ".net" - generally speaking, three letters after the "." => Then you can cut out the string before that, again using INDEX() and then LEFT().

-- The front end must be right after a BLANK, so once you have made a cut after the email-id, that should be the last Subfield() ...

HTH

Best regards,

DataNibbler

[isingh30]

Try this -

= only({<From = {'website@vinod.ie'}>}From)

Thank you!