Forum Discussion

k2s2's avatar
k2s2
Frequent Visitor
4 years ago

Split *multiple* columns by non-digit to digit

Hello,   Using the menus, I can split a column into two, which creates M code something like below if my column is named Column1     #"Split Column by Character Transition" = Table.SplitColumn(...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago
let
    Origine = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("JcvBDcAgDEPRXXLmVhzSO3KRMwJi/zVKqeTb85/ToiEgaoi0Yo6oXd1WmebhEU7+gv0kn+SxiusSUzpNgwbzAJozubehOfz+smFrvQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Colonna1 = _t, Colonna2 = _t]),
    #"Modificato tipo" = Table.TransformColumnTypes(Origine,{{"Colonna1", type text}, {"Colonna2", type text}}),
    colstosplit={"Colonna1","Colonna2"},
    ts= List.Accumulate(colstosplit, #"Modificato tipo", (s,c)=>Table.SplitColumn(s, c, Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c)), 
     {c&".1", c&".2"}))

in
    ts