How to Check Uppercase and lowercase string in Alteryx

[Ashwin1]

Hi All, 

         How to check uppercase and lower case string in between white spaces and special characters. 

I used a regex formula which is working fine with white spaces ,uppercase and lowercase but not with Special characters. Can someone help out with the regex formula for that.

This is the one i am using now "[A-Z\s]*". This one is not doing anything with special characters. 

Eg Data - SAINT OF CULTURE & CREATIVE 

Thanks

Ashwin

[DavidP]

Hi @Ashwin1 

Unless you know which special characters to include and can add them into the set, you're probable better off defining a set that does not contain what you don't want, i.e. [^a-z]

[grazitti_sapna · Accepted solution]

Hi @Ashwin1 , give this a try.

Regex- ([A-Za-z\s].*)

[Ashwin1]

Thanks Both.. It worked..