nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter out Name(string) with ANY special characters

mrgrohl

Hi community!!

I'm trying to bring back names that have ANY kind of special character - just stuff that doesn't belong in a name. Some examples are:

John Sm!th

Mary H@rris

Susan Mar$h

The majority of the names on the tables are fine, I just need to filter out the 'bad' names and have those on a file/spreadsheet to have those addressed. I've tried Regex and can't seem to bring just those back. Any help is greatly appreciated. Thank you!!!

Community

Search Feedback

Accepted answers

oneillp111

Couple Examples below

if REGEX_Match(replace([Names],' ',''), '.*?\W.*?') then 'Bad' else 'good' endif

if REGEX_Match([Names], ".*[\&@$\!#\%\^\*/\?].*") then 'Bad' Else 'Good' endif

All comments

FrederikE

Hey @mrgrohl,

You could use a filter with this formula:

REGEX_Match([Field1], "[a-Z ]*")

This will exclude all rows with any charater that is not a letter or a whitespace.

oneillp111

Couple Examples below

if REGEX_Match(replace([Names],' ',''), '.*?\W.*?') then 'Bad' else 'good' endif

if REGEX_Match([Names], ".*[\&@$\!#\%\^\*/\?].*") then 'Bad' Else 'Good' endif

mrgrohl

Thank you for both responses! Marking as complete

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703