如果您在组成IDN号码的一组数字之后有数字，请尝试这个稍微复杂一点的版本：

• 在IDN上进行第一次拆分
• 然后在从数字到非数字的转换上拆分
• 请注意，通过将Added Column指定为type text，我们将保留IDN中的所有前导零。如果愿意，您可以将其指定为type number或Int64.Type，这将删除所有前导零。

let

//Change next line to reflect actual data source
    Source = Excel.CurrentWorkbook(){[Name="Table7"]}[Content],

//Set data type
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Short description", type text}}),

//Extract the first set of digits after "IDN"
    #"Added Custom" = Table.AddColumn(#"Changed Type", "IDN", each 
        Text.Trim(
            Splitter.SplitTextByCharacterTransition({"0".."9"}, (c) => not List.Contains({"0".."9"}, c))
                (Text.AfterDelimiter([Short description],"IDN")){0}), type text)
in
    #"Added Custom"

此类数据清理应在Power Query中完成。
加入新数据行，并输入下列程式码：

let 
a = Text.AfterDelimiter([Column1],"IDN"),
b = List.Transform({a}, each Text.Select(_, {"0".."9"}))
in b{0}

完整代码：

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk4tUzBV8HTxU7A0MbcwVtBVcCxNyfTITM9QitWJVvJNLUksSszNL80rASsytzAxN7LUdfX3AaoMT03JTU1Rio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each let 
        a = Text.AfterDelimiter([Column1],"IDN"),
        b = List.Transform({a}, each Text.Select(_, {"0".."9"}))
        in b{0})
in
    #"Added Custom"