за ответ сойдет? Table.SplitColumn(Источник, "nm", Splitter.SplitTextByCharacterTransition((c) => not List.Contains({"?"}, c), {"?"}),2)
let Source = #table( 1, {{"text1"}, {"text1/?text2?ntext3?utmtext4?sreftext5"}, {"text1?sreftext2?ntext3?utmtext4/?text5"}} ), SplitAny = Table.SplitColumn( Source, "Column1", each let l=Splitter.SplitTextByAnyDelimiter({"/?","?n","?utm","?sref"}, QuoteStyle.Csv, false)(_) in {l{0}, Text.Replace(_,l{0},"")}, {"Column1.1", "Column1.2"} ) in SplitAny
Обсуждают сегодня