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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels