Forum Discussion
Helper IIIBI Desktop Not Recognizing Difference Between Upper and Lower Case Letters
oh my bad here use this https://invisibletext.com/
insetead of the u+200e just copy this text in this link
Memorable Memberhello rbowen
lets say you have this table
as you see it is adding them up together the lowercase and uppercase,
a wrokaround is to add an invisible space to the text with lower cases do this
add a new custom column
if
Text.StartsWith([Data], Text.Lower(Text.Start([Data], 1))) then [Data] & "<u+200e> " else [Data]
- rbowen
Thanks Anon, this appears to be getting closer, but I'm not getting the clean lower case values showing in your example. Here's the M code I'm using:
=if
Text.StartsWith([SubAccountNumber], Text.Lower(Text.Start([SubAccountNumber], 1))) then [SubAccountNumber] & "<u+200e> " else [SubAccountNumber]And what I end up with is this:
The SubAccountNumber reference column is formatted as text, as is the new column. The reference column also contains straight numeric values (100, 200, 300, etc) and I'm wondering if that's throwing off the calculations for the new column - although, as I said, the reference column is formatted as text. Am I missing something?
- eliasayyy
oh my bad here use this https://invisibletext.com/
insetead of the u+200e just copy this text in this link- rbowen
That did the trick! Thank you.