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
Solved! Go to Solution.
Regex Expression : ^[a-zA-Z'-]{2,}$
Regex: [A-Z'-]{2,}
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.
Thanks @Hammad_Rashid That worked very well.