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
Helper IIIUnfortunately, I can't do that. I have to maintain the upper/lower case mix because they reference different locations based on the letter case. There are multiple combinations of this with different letters as well - i.e., A/a, B/b, I/i, etc. Is there a way in PowerQuery to create a custom column of the sub account column using Unicode?
Community Championrbowen In short, yes. I demonstrate the technique in this video:
- rbowen
Yikes! While I completely the 'case insensitivity' thing is ridiculous (much like the 'additivity' issue), the solution in your video is well beyond my BI/PowerQuery kung fu - especially given the sheer number of alphanumeric combinations in my data. Was really hoping there would be a relatively straightforward way to do this - surely there's a way in PowerQuery to take a column and either convert it's existing values to unicode, or create a new column based on the original and parse those values into unicode. It's becoming increasingly clear I may be indulging in wishful thinking. Perhaps I need to investigate doing the conversion on the front end with SQL.
Greg_Deckler , I like your video. Tried to solve it your way, but throws me an error, that I don't find searching the web...
=if Text.StartsWith([Data], Text.Lower(Text.Start([Data], 1))) then [Data] & UNICHAR(8203) else [Data]Expression.Error: The name 'UNICHAR' wasn't recognized :
- Greg_Deckler
Florisz UNICHAR is a DAX funtion. In M you would need to use Character.FromNumber
