(text as text, optional char_to_trim as text) =>
let
char = if char_to_trim = null then " " else char_to_trim,
split = Text.Split(text, char),
removeblanks = List.Select(split, each _ <> ""),
result=Text.Combine(removeblanks, char)
in
result
非原創(chuàng)稚机，在國外網(wǎng)站找到的对室。不過還沒找到實際應(yīng)用場景夯缺。
