Removing Special Characters From Email Addresses

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

Regex

Parse

Help

Accepted answers

binu_acs

@Deano478 One way of doing this

RemoveChar_200423.yxmd

All comments

ShankerV

Hi @Deano478

Please use the regex below.

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

Many thanks

Shanker V

binu_acs

@Deano478 One way of doing this

RemoveChar_200423.yxmd

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

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703