RegEx Expression help please – Alteryx Community

Hi

 Can someone please help with writing RegEx expression to filter out all special characters, brackets, numbers. I am cleaning a first name column which can only have alphabets, – (hyphen) and ‘ (apostrophe). 

Also it should flag single alphabet field as False. Thank you

 

REGEX True/False output should be like this

 

Alex!   – False

Jam@es – False

Li%sa – False

(John – False

[Raj – False

Tony\ – False

George~ – False

Jamy* – False

Rob^ – False

Mary-Anne – True

O’Connor – True

Jacky12 – False

Rob0rt – False

n – False

L – False

warren – True

 

 

 

 

 

 

 

 

 

 

 

 

 

Read more here: Source link