SOLVED
Extracting Email Address
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
KamenRider
11 - Bolide
02-12-2024
08:31 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I attached a file where it consist of owner names and its email address in one cell being separated by a semi-colon. I have provided different scenarios and would like results to be like this:
Please advise.
Thanks,
Kamen
Solved! Go to Solution.
2 REPLIES 2
17 - Castor
02-12-2024
08:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @KamenRider there's a bunch of ways to do this but here's one. First we just split the records to a row each using Text To Columns, with semicolon as the delimiter. After that you just need to take your pick on how you want to parse really, I've used the following:
Left([Email],STRCSPN([Email],'<')-1)
REGEX_Replace([Email], '.*<([^>]+).*', '$1')
For the [Name] and [Email Add] respectively. Hope this helps!
02-12-2024
09:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
