Tokenize email address

Hi Everyone,

Could you please give some help?

I'm rookie in RegEx and would like to tokenize the simple structure below.

Surname1, Name1 (Abb1) <userid1@samecompany.com>; Surname2, Name2 (Abb2) <userid2@samecompany.com>; Surname3, Name3 (Abb3) <userid3@samecompany.com>; ...

Regards,

Reinaldo S. Araujo

Regex

Parse

Accepted answers

jdunkerley79

Hi @rarauj26

Have amended. See attached.

Pure Regex.yxmd

All comments

LordNeilLord

Hey @rarauj26

Can you give an example of what you want the output to be?

If you want to split in to rows, text to columns using ; as the delimiter and "split to rows" function would work

Then if you want to parse out the email address the RegEx tool using <(.*)> will give you the email address

LordNeilLord

Double post from me

rarauj26

Hi Neil,

yes!

We want to split by rows and the columns with the fields

field1 field 2 field3 field4

row1 Surname1 Name1 Abb1 userid1

row2 Surname2 Name2 Abb2 userid2

row3 Surname3 Name3 Abb3 userid3

Regards,

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167