powerquery,从分隔列表的分隔列表创建表,包含分隔键值对

(Text as nullable text) as nullable table =>
    try
        Table.FromRecords(
            List.Transform(
                Text.Split(Text, "|"),
                (r) =>
                    let
                        SplitAnyList = Text.SplitAny(r, "=,"),
                        Record =
                            Record.FromList(
                                List.Alternate(SplitAnyList, 1, 1),
                                List.Alternate(SplitAnyList, 1, 1, 1)
                            )
                    in
                        Record
            )
        )
    otherwise null