在power query里如何指定提取文本？

ThxAlot

源数据的格式还是挺规矩的，简单处理一下就可以完成。

1. let
   
2.     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("hZJLCsIwFEX30rGD2/pfS+leCg6sA1GhgmAFEQRFUQeCv7obE83ILdimohhvdZacd9/Lh+O6lmOLw1bE/nU6U82emowsr/CkN78hx/vLaWcW1GKQdMigK6Plm4pjP8l+UT1arocimJPppJB1iHY6zYybNN2f29mZ9zjIWu9xKz+hL/mRUKEvwpXsb1Szo2m21DVbRoHJHMKKhJUIKxNWIaxKWI2wOmE2GGQvsV9PcUAtQJ4FoBaAWoA8C5BnAagFoBbgrwUs8WkBfliQ1mB+noamByAegHgA4gGIByAegHgA4gGYB2Ae4O2B9wA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Raw = _t]),
   
3.    
   
4.     #"Added Custom" = Table.AddColumn(Source, "Custom",
   
5.         each [
   
6.             t = Text.Select([Raw], {"0".."9","年"}),
   
7.             yymm = Text.Split(t, "年"),
   
8.             rec = [Yr=yymm{0}, Mth=yymm{1}, Misc=Text.Remove([Raw], Text.ToList(t)&{"月"})]
   
9.         ][rec]
   
10.     ),
    
11.     #"Expanded Custom" = Table.ExpandRecordColumn(#"Added Custom", "Custom", {"Yr", "Mth", "Misc"}, {"Yr", "Mth", "Misc"})
    
12. in
    
13.     #"Expanded Custom"

复制代码