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!!!

[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 · Accepted solution]

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