Function to check whether a text is in upper or lower case

[danextian]

Hi,

Is there an existing function to check whether a text is in  upper or lower case or do i still need to create a custom function?

[Anonymous]

You could compare the string with the result of UPPER() on that string.

You must use the EXACT() function for this:

IsUpperCase = IF(EXACT(UPPER(data[string]), data[string]), TRUE(), FALSE())

On a side note, I just noticed a bug with the Enter Data option (if you enter the same value in different casing, it just makes the casing consistent).

[jrmaier]

I used this to check Prefixes of constituents. If a person doesn't have a prefix it is returning a "True" value. Is there something I can add to ignore empty records?

IsUpperCase = IF(EXACT(UPPER(data[string]), data[string]), TRUE(), FALSE()) 

[danextian]

I should have been more specific. Is there one for M.

[MarcelBeug · Accepted solution]

No. You can create a custom function using Text.Lower and/or Text.Upper, like:

(Text as text) as logical =>
let
    IsTextAllUpperCase = Text.Upper(Text) = Text
in
    IsTextAllUpperCase

[danextian]

Thanks @MarcelBeug and @Anonymous

I didn't  think of comparing a letter to it's uppercase version.