i want to create a filter to check if all the values in the colunm are in upper case

[Raj]

how to use the filter tool to check if all the values in the column are in upper case

example- ABC
Acdcf

xyz

ref

earth

TEST

i want to apply filter and T anchor should show - TEST and ABC while F contains rest of the values.

[binu_acs · Accepted solution]

@Raj 

[caltang · Accepted solution]

Try this my friend:

REGEX_Match([Field1], Uppercase([Field1]),0) = -1

Solution courtesy of @NicoleJohnson : https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Filter-for-string-values-that-... 

[mbarone · Accepted solution]

Since there's no function that does this, and because "=" is not case sensitive, you'll have to create a new field (say, "UPPER") where UPPER = Uppercase([your field here]).  Then Join it to itself on [your field here] = UPPER.  Join IS case sensitive, so only records that are fully uppercase will come out of the J anchor.

[Raj]

Thank you every one for help

[mbarone]

Nice one @binu_acs ! Didn't know regex had \u !

[caltang]

@Raj have you tested my solution as well? If it helps, you can mark it as an accepted solution as well to help others.

My solution is similar to what @mbarone described.

[Raj]

@caltang @binu_acs @mbarone 
Do we have anything to check the Title case?
Uttar Pradesh
Delhi

are true

while

Uttar pradesh
delhi

DELHI

are False

[caltang]

There is: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Title-case-the-first-word-of-a... 

[Raj]

@caltang i think there is mis understanding at your end please go through the challenge again