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
Thanks again Fred, this looks promising!!
I'm a newbie so the syntax adding this conditional column using the list.contains is confusing me and giving me errors.
I'll play around with it more after the Holidays
Thanks and have a great New Year's Day.
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]