Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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