Forum Discussion
Solved
Converting list elements based on their lengths
Hello, One column in my table is a list of strings. I would like to change the strings to lower case if their lenghts is greater than 1. Name Types N1 A,ABC,B,CDF,DF N2 H,JK...
Here is one way to do this...
= Table.TransformColumns(previousQueryStep, {{"Types", each Text.Combine(List.Transform(Text.Split(_, ","), each if Text.Length(_) > 1 then Text.Lower(_) else _), ","), type text}})Using your example table you end up with...
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8jNUUFBQ0lFy1HF0ctZx0nF2cdNxcVOK1QFKGQHFPXS8vH10nNx1XJx1nJViYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Name " = _t, Types = _t]),
chars = List.Buffer({"a".."z", "A".."Z"}),
result = Table.TransformColumns(
Source,
{
"Types",
(x) => Text.Combine(
List.Transform(
Text.Split(x, ","),
(w) => if List.Contains(chars, w) then w else Text.Lower(w)
),
","
)
}
)
in
result