Alteryx Designer Desktop Discussions

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

RegEx Expression help please

Amsaini15
6 - Meteoroid

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 REPLIES 4
Hammad_Rashid
11 - Bolide

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

 

 

Capture.PNG

sparksun
11 - Bolide

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

 

1.jpg

 

Amsaini15
6 - Meteoroid

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
6 - Meteoroid

Thanks @Hammad_Rashid  That worked very well.

Labels