Is there a text function for checking all case in Power Query M

[Anonymous]

Hi all,

I am wondering if there is  function in the M Power Query to check all the letter in a text consist of all upper case or lower case. 

For example:

• "Trailer; Mario Box Tandam 2000GVM" will return   "True" (because this text consist of some letters with lower case"
• "TRUCK ISUZU NPR200 MED SC TT 4.3L M D" will return   "False" (because this text consists of all letter with upper case"

Please advise if there is such function as I checked in the Text function, there isn't.

If there is not, do you have any solution to do this?

Regards,

Tuffy

[parry2k · Accepted solution]

@Anonymous in edit query, add new custom column with following expression to get true/false

[Column1]<>Text.Upper([Column1])