按单词分拆

shufeabb

按单词来拆分.rar (19.9 KB, 下载次数: 19)

2021-7-18 07:06 上传

点击文件名下载附件

ThxAlot

把and/or等关键词用某个特殊符号替换掉后再用Text.Split就行。

ThxAlot

ThxAlot 发表于 2021-7-18 17:20
把and/or等关键词用某个特殊符号替换掉后再用Text.Split就行。

当然，也可以全部扔给regex一起处理也就没那么多啰嗦事了

1. let
   
2.     RE = (regex as text, str as text) => Web.Page("<script>var regex = " & regex & "; var str = """ & str & """; var res = str.split(regex).join('|'); document.write(res)</script>")[Data]{0}[Children]{0}[Children]{1}[Text]{0},
   
3. 
   
4.     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("lY8xCsJAEEWvMqRSdM3MbjbJahWixEKDhGgQSRHIFoK4GPUynsU7eQUVLWymsJvPe//D7Hbe+mwhWZRQOneAlZ+PYRmTCY1PRqDx6iGvTCgSKDlFSi3RJ4EEzbH9yVxj1Zz3jjRDp1UmEElqwRmbpBCKYVWplJqnlGlw3SfNUjnPuK1/fRUEISXQy+zRds0BXkb/3QwUYsp0KA71gGMGo88vubtAYU/XfWfb0Xv3a+WP+23pWvs65dar6yc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Final = _t]),
   
5.     #"Added Custom" = Table.AddColumn(Source, "Custom", each List.Skip(Text.Split(RE("/([:：]|and|or) ?/gi", [Final]),"|"),1))
   
6. in
   
7.     #"Added Custom"

复制代码

deadzlq

PowerQuery参考解法