RegEx Parse email info

Hello,

I'm not very experienced with regex and I have a field I'm trying to parse the email information from whether it has an address or shows 'None'

INPUT:

[{'fullName': 'user name', 'email': 'user.name@emailaddress.com'}]
[{'email': None}]}, {'displayUserInfo': [{'email': None}]
[{'email': 'user@emailaddress.com'}]
[{'fullName': 'name user', 'email': 'nameuser@gmail.com', 'company': 'Company Name, LLC'}]

DESIRED:

user.name@emailaddress.com

None

user@emailaddress.com

nameuser@gmail.com

Using Regex101 I used the below and it does parse out the email address but it doesn't work in the RegEx tool.

\'email\'\:\s\'(.+?)\'

Regex

Parse

Preparation

Accepted answers

kathleenmonks

@BonusCup

'email': '(.*\.[[:alpha:]]{3})'

This will change it to look for a period followed by any three letters - so that can work for those other domains. Nice call! If this solves your problem, please be sure to mark as the solution!

kathleenmonks

Hi @BonusCup,

An alternative to using RegEx here is to use the JSON parse tool. You would first need to change the single quotes to double quotes, but then you could pick up every possible variation of the email address given that it comes after 'email':

Attached is an example of how this would work. I changed one of your original examples to .world

Parse_email.yxmd

All comments

kathleenmonks

Hi @BonusCup,

Here is one way to do it with a RegEx:

'email': '(.*com)'

BonusCup

@kathleenmonks Thanks so much, I figured it was something 'easy'. In the data coming in so far is just '.com' but what if other domains start to appear? i.e .edu, .net, .org, etc...

kathleenmonks

@BonusCup

'email': '(.*\.[[:alpha:]]{3})'

This will change it to look for a period followed by any three letters - so that can work for those other domains. Nice call! If this solves your problem, please be sure to mark as the solution!

BonusCup

@kathleenmonks Perfect. Thank you for the help and quick response.

BonusCup

@kathleenmonks, Bringing this back to the top. Thanks again for your help before. In some new data I'm getting email addresses with varying character counts for the domain (.com, .it, .world, .kitchen, .company, properties, etc...)

Currently, I'm using the below regex to pick up the ones that have 2 and 3 character domains. Instead of adding new formulas for 4 - 10, is there a regex formula to parse the email addresses that have anywhere from 2 or more characters for their domains?

Current regex:

('email': '(.*\.[[:alpha:]]{3})')|('email': '(.*\.[[:alpha:]]{2})')

kathleenmonks

Hi @BonusCup,

Attached is an example of how this would work. I changed one of your original examples to .world

Parse_email.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703