Forum Discussion
Table visualization and case sensitivity
Happy New Years Day!
Add custom column, not conditional column.
Conditional Column options are too basic to handle List.Contains or invisible characters.
Then paste into the custom column window:
if List.Contains(List.Transform({97..122}, each Character.FromNumber(_)), Text.Start([DATABASE_NAME], 1)) then Character.FromNumber(8236) else ""
I'm assuming your column is named [DATABASE_NAME], but if not, then substitute the right name.
Basically...
List.Contains({a..z}, "e" is true.
List.Contains({a..z}, "E" is false.Fred
Happy New Years Day!
Add custom column, not conditional column.
Conditional Column options are too basic to handle List.Contains or invisible characters.
Then paste into the custom column window:
if List.Contains(List.Transform({97..122}, each Character.FromNumber(_)), Text.Start([DATABASE_NAME], 1)) then Character.FromNumber(8236) else ""
I'm assuming your column is named [DATABASE_NAME], but if not, then substitute the right name.
Basically...
List.Contains({a..z}, "e" is true.
List.Contains({a..z}, "E" is false.
Fred
Thanks Fred and everyone.
Appending a space if lower case did the trick!
if List.Contains(List.Transform({97..122}, each Character.FromNumber(_)), Text.Start([DATABASE_NAME], 1)) then [DATABASE_NAME]&Character.FromNumber(8236) else [DATABASE_NAME]