Dynamically Split String of Characters into Equal Chunks using Excel Functions

preview_player
Показать описание
Input String - ABCDEFGHIJKLMNOP
Chunk Size - 5

Output - {"ABCDE";"FGHIJ";"KLMNO";"P"}
Рекомендации по теме
Комментарии
Автор

This 2 step M code works as well

let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
Headers = Table.FromColumns(Table.AddColumn(Source, "Custom", each List.Transform({1..Number.RoundUp(Text.Length([String])/[Size], 0)}, each "Column" & Number.ToText(_)))[Custom])[Column1],
#"Added Custom" = Table.ExpandTableColumn(Table.AddColumn(Source, "Custom", each Table.FromRows({List.Transform(List.Split(Text.ToList([String]), [Size]), each Text.Combine(_, ""))})), "Custom", Headers)
in
#"Added Custom"

excelenthusiasts
Автор

Hi. Here's my solution

=DROP(REDUCE("", SEQUENCE(ROUNDUP(LEN(B2)/B3, 0), , 1, B3), LAMBDA(a, i, VSTACK(a, MID(B2, i, B3)))), 1)

excelenthusiasts
join shbcf.ru