How to Check Uppercase and lowercase string in Alteryx

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

Developer Tools

Accepted answers

grazitti_sapna

Hi @Ashwin1 , give this a try.

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

All comments

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

Hi @Ashwin1 , give this a try.

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

Ashwin1

Thanks Both.. It worked..

Quick Links

Unanswered
Community Events
Groups

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167