Removing Special Characters From Email Addresses

[Deano478]

Hi all,

I have a list of email addresses like below and what I'm trying to is just remove any special characters from the emails:

So ideally they would be for example like: Lisa.OSullivan@test.com

Martin.O'Callaghn@test.com

Lisa.O'Sullivan@test.com

John.O'Shea@test.com

Mick.O'Hara@test.com

Dave.O'Hanka@test.com

Cheers for any insights in advance

[ShankerV]

Hi @Deano478 

Please use the regex below.

REGEX_Replace([Field1], "[^a-z@.]",'')

Many thanks

Shanker V

[binuacs · Accepted solution]

@Deano478 One way of doing this

[IraWatt]

Hey @Deano478,

What is the final result you are looking for?

You can for instance use this regex to remove any non alpha numeric characters:

REGEX_Replace([test], "[^a-zA-Z_0-9 ]", " ")

The Square brackets indicate a set of characters you are looking for. The ^ is a not, there fore it replaces any non letter or number character to a space. Getting you this result:

[Deano478]

@binuacs  That worked like a charm as form me Regex is something I definitely need to get a better understanding of