Text.select

上题:
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
    小写的文本