Text.select

2020-04-26 11:41:54 ⋅ 1985 ⋅ 0 ⋅ 1

上题:
file
结果:
file

let
    源 = Excel.CurrentWorkbook(){[Name="表1"]}[Content],
    按照字符转换拆分列 = Table.SplitColumn(源, "Quantity", Splitter.SplitTextByCharacterTransition( each _<":" and  _<>"/", each _>="A" ), {"Quantity.1", "Quantity.2"}),
    小写的文本 = Table.TransformColumns(按照字符转换拆分列,{{"Quantity.1", each Text.Select(_,{"0".."9","."}), type text}})
in
    小写的文本

自由转载-非商用-非衍生-保持署名（创意共享3.0许可证）