Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Proud to be a Super User!
Solved! Go to 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
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).
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())
Proud to be a Super User!
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
Thanks @MarcelBeug and @Anonymous
I didn't think of comparing a letter to it's uppercase version.
Proud to be a Super User!
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |