主题：[求助]如何匹配地址码？

不理解！

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:aaa.egd

参考：地址包含现有建筑物前两个中文文字是可以的！

下载信息  [文件大小：   下载次数： ]

点击浏览该文件:aaa.egd

参考：地址包含“现有建筑物”（限制四个中文字符）中连续两个中文文字，可用刷新公式：

If(Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",0,4),[地址])>-1 And Len(Mid("""),"#",""",0,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",0,4)),If(Instr(Mid(""")+""",0,4))"+","""""+Rept(")",[%A%])) <> "",Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",0,4),[地址])>-1 And Len(Mid("""),"#",""",0,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",0,4)),If(Instr(Mid(""")+""",0,4))"+","""""+Rept(")",[%A%])),If(Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",2,4),[地址])>-1 And Len(Mid("""),"#",""",2,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",2,4)),If(Instr(Mid(""")+""",2,4))"+","""""+Rept(")",[%A%])) <> "",Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",2,4),[地址])>-1 And Len(Mid("""),"#",""",2,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",2,4)),If(Instr(Mid(""")+""",2,4))"+","""""+Rept(")",[%A%])),If(Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",4,4),[地址])>-1 And Len(Mid("""),"#",""",4,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",4,4)),If(Instr(Mid(""")+""",4,4))"+","""""+Rept(")",[%A%])) <> "",Eval("If(Instr(Mid("""+Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|"",""|"","""+Substitute(ListFor("表1","现有辖区建筑物",2),"|",""")+""|""+Substitute(""|@|#|"",""|"",""")+""")"),"@",""",4,4),[地址])>-1 And Len(Mid("""),"#",""",4,4))=4,FindText(""表1"",""村社区代码"",""现有辖区建筑物"",""Instr"",Mid("""),"|",""",4,4)),If(Instr(Mid(""")+""",4,4))"+","""""+Rept(")",[%A%])),"")))

其中表达式变量[%A%]：Aggregate(4,1,3,Rows,3,1)