Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLUCIONADO

RegEx Expression help please

Amsaini15
Meteoroide

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

 

 

 

 

 

 

 

 

 

 

 

 

 

4 RESPOSTAS 4
Hammad_Rashid
Bólide

Regex Expression : ^[a-zA-Z'-]{2,}$

 

 

Capture.PNG

sparksun
Bólide

Regex: [A-Z'-]{2,}

 

1.jpg

 

Amsaini15
Meteoroide

Awesome. Thanks mate. That was very quick. Let me give it a go when I reach home and mark the one that has worked as solution.

Amsaini15
Meteoroide

Thanks @Hammad_Rashid  That worked very well.

Rótulos