Email address parse, RegEx?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I need some help parsing a list of email addresses. They are in two formats:
monica.geller@aaa.com
chandler.m.bing@aaa.com
What I require is a separate first name and second name column and discarding the middle initial i.e:
First Second
Monica Geller
Chandler Bing
Thanks for your help in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This works very well indeed.
Much appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Please try:
(\w+)\.*\w+\.(\w+)\@.*
inside of a regex tool to parse.
cheers,
mark
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @OllieClarke
I have a similar query to @StephenMoss . The email address formats are the same but my desired output is slightly different:
Essentially I'd like to:
- Keep the middle initial
- Have the full name displayed in one column (first name, middle initial and surname)
- have the first letter of first and surname capitalised the middle initial capitalised too
Please can you help?
Many thanks!
KA
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @arundaka02 try this formula in a formula tool:
TRIM(TITLECASE(REPLACE(REGEX_REPLACE([email],'@.*',''),'.',' ')))
Hope that helps,
Ollie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew your method above cuts off names. For example, james.smith@xy.com, the first name becomes "jame".
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @bb213,
If you have a bit of regex that is close to the desired output, you can play around with and test different regex configurations here: https://regex101.com/
It's 100% free and user friendly. I've found this site extremely useful lately.
Hope that helps!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there a Simple way to understand, Look like your parse finding difficult to understand.
I am a beginner in Regex.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Your regex is not working for me.
I want for
someone1234@gmail.com
