删除空格的PowerQuery代码

(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

非原创，在国外网站找到的。不过还没找到实际应用场景。