Аркадий Асанов, полученный результат можно объединить в одной ячейке:
Код |
---|
let
src = Excel.CurrentWorkbook(){[ Name = "data" ]}[Content],
transform = Table.TransformColumns (
src,
{
"Картинка 1 1",
( t ) =>
List.Transform (
List.Generate (
() => [ text = t, result = Text.BetweenDelimiters ( text, "/wa-data/", ".webp" ), k = if result = "" then 0 else 1 ],
each [k] > 0,
each [ text = [text], result = Text.BetweenDelimiters ( text, "/wa-data/", ".webp", [k] ), k = if result = "" then 0 else [k] + 1 ],
each [result]
),
( x ) => "/wa-data/" & x & ".webp"
)
}
),
transform2 = Table.TransformColumns ( transform, { "Картинка 1 1", ( x ) => Text.Combine ( x, ";#(lf)" ) } )
in
transform2 |
либо поместить в разные:
Код |
---|
let
src = Excel.CurrentWorkbook(){[ Name = "data" ]}[Content],
transform = Table.TransformColumns (
src,
{
"Картинка 1 1",
( t ) =>
List.Transform (
List.Generate (
() => [ text = t, result = Text.BetweenDelimiters ( text, "/wa-data/", ".webp" ), k = if result = "" then 0 else 1 ],
each [k] > 0,
each [ text = [text], result = Text.BetweenDelimiters ( text, "/wa-data/", ".webp", [k] ), k = if result = "" then 0 else [k] + 1 ],
each [result]
),
( x ) => "/wa-data/" & x & ".webp"
)
}
),
expand = Table.ExpandListColumn ( transform, "Картинка 1 1" )
in
expand |