Extracting email address using regex

Hello!

There are some solutions out here already, but I can't quite get mine to do exactly as needed.

I am trying to extract an email, and on occasion there is more than one, but also another email address I don't want. Data would look something like this:

Email Address: sjefferson@gmail.com

(1) Beneficiary Name: John Smith

(1) Beneficiary Street Address: 123 Main St

(1) Beneficiary Street City: Anytown

(1) Beneficiary Email: jsmith@gmail.com

(2) Beneficiary Email: ljones@aol.com

Results I need are jsmith@gmail.com and ljones@aol.com But, NOT the sjefferson@gmail.com

I tried: Beneficiary email:(.+@\w+[\.\w?]+)

But that would only pull 1 email and if the one labeled Email Address was listed first, it pulled that one.

Thank you in advance,

Kim

Regex

Accepted answers

CarliE

@kas ,

Attached is a workflow with 2 streams for 2 different ways

Extracting email address using regex.yxmd

All comments

CarliE

@kas

Try this out!

Email:\s(.+)

Its taking all characters after Email: -- side note here, the website regex101 is a very helpful resource as you're testing out your regex

If this provided a solution, make sure to mark it as solution to help other members out!

Thanks

phottovy

@kas ,

As @CarliE pointed out, you can simplify your expression to pick up all of the emails. The reason your expression isn't working for the first email address is the word "Beneficiary" in the expression. If you simplify it to just look for the word email and add .* before the : , you will pick up all three. Try this modified expression:

Email.*:\s(.+@\w+[\.\w?]+)

IraWatt

Hey @kas,

Not sure how your data is structured but here's two examples of how I would get the email addresses:

Workflow0506.yxmd

kas

@CarliE

Hello,

Thank you for the quick response...I should have added a bit more to my data set - your Regex pulled too much.

Email Address: sjefferson@gmail.com

(1) Beneficiary Name: John Smith

(1) Beneficiary Street Address: 123 Main St

(1) Beneficiary Street City: Anytown

(1) Beneficiary Email: jsmith@gmail.com

(2) Beneficiary Email: ljones@aol.com

(1) Amount: $xxx

(2) Amount: $xxx

Etc...there is more misc stuff afterwards...

thank you!

kas

@CarliE

Yes, but I don't want everything after the email address...there is additional information and the emails aren't listed one after the other.

Thank you though.

phottovy

Sorry, I misread the question. I believe @CarliE 's updated expression should work now. I'm wondering if a better approach would be to parse the field names and values for all rows first. Then it would be pretty easy to extract the beneficiary email addresses as well as any other fields you may need in the future.

CarliE

@kas ,

Attached is a workflow with 2 streams for 2 different ways

Extracting email address using regex.yxmd

kas

@phottovy

I'll give @CarliE updated version a try...for the sake of brevity, I didn't list all the unnecessary data lines I was extracting it from, it can get very lengthy, otherwise parsing all the rows would have been a good option.

Thank you!

kas

@CarliE

This is perfect...thank you for your patience, very much appreciated!

Kim

kas

@IraWatt

Thank you...yours is very close to what the final solution was - only missing piece was isolating just the ones with "Beneficiary" before email.

Thanks so much!

IraWatt

No worries @kas glad we could help 😄

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703