取PO号码出来

shufeabb

取出PO的号码.rar (7.37 KB, 下载次数: 34)

2021-9-28 13:53 上传

点击文件名下载附件

消灭零公里

用笨方法分几步来呗

sucx007

1. = Table.AddColumn(源, "PO", each Text.SplitAny(Text.Middle([Descriptions],Text.PositionOf([Descriptions],"PO"),99),"  _；;"){0})

复制代码

tony@cq

= Table.AddColumn(源, "PO号码", each "PO#"&Text.BetweenDelimiters(List.FindText(Text.SplitAny([Descriptions],", ;"),"PO#"){0},"PO#","_"))

henry6

PQ自定义函数引用正则表达式也能达到目的

ThxAlot

没有什么字符串处理是REGEX搞不定的

1. let
   
2.     RE = (regex as text, str as text) =>
   
3.     let
   
4.         html = "<script>var regex = " & regex & "; var str = """ & str & """; var res = regex.exec(str); document.write(res)</script>",
   
5.         res = Web.Page(html)[Data]{0}[Children]{0}[Children]{1}[Text]{0}
   
6.     in res,
   
7. 
   
8.     Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WerGh+dnULS/WbdA1sjAyer+nx9AgIuLFlp3Pp6x4uagNSOqGmwW46gT4KTu6BhkEe7j6+JgY6jybuuFle78hUPnTnmlP1y57OrkRyA7wV45wNjI0AAIjQ13DeP+SjNSi4nhdpVgdWlpkBLPICMjTM7DUMzKA2onmoEMLDA2MzYwOLQgAChmaWBxaALEZbvTT9XtetG952jf/acOep4vmPe1acGiBl6+uf4hHsClQ29O2TVArlI1NzA2fzlnxdPeup9uXPl/RjepXNPdB7DWG2WtJvL3BwZYk2uvs6Aey2NBY19D66fydL9atfbJ724v9s5/2L37WtfRp62ZgkD/t73q6a/6z6cufd64E2d67+vmU+U+XtDyf0AaUtX6yY+3T7fMgqq2VDQzMjSyNDYzikYVB9sUCAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Descriptions = _t]),
   
9. 
   
10.     #"Added Custom" = Table.AddColumn(Source, "Custom", each RE("/PO#[a-z0-9\-]+/i", [Descriptions]))
    
11. in
    
12.     #"Added Custom"

复制代码

chenyun1234

=TRIM(MID(A3,FIND("PO#",A3,1),15))

Seriouse54088

公式啥的太绕了，我只会粗暴的正则 PO#[A-Z\d-]+