Tokenize email address

[rarauj26]

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

[rarauj26]

Hi @jdunkerley79,

for my experience RegEx still too trick.

Could you please share a solution in the following format:

Record#      Field1            Field2       Field3       Field4

1                 Surname1      Name1     Abb1        userID1

2                 ...                    ...             ...             ...             

---

Your post I got the Field4 with the complete email (userID#@samecompany.com)

Regards,

[jdunkerley79 · Accepted solution]

Hi @rarauj26

Have amended. See attached.

[rarauj26]

Hi @jdunkerley79,

it was great!

Thank you so much.

Now I'll check all information you sent me in order to understand how RegEx works.

Regards,