求解FineReport公式

读取G8I8K8M8四个单元格里面的中文字符，四个表格里的数据，不是规范的，有空数据，有空格符号顿号冒号等等符号，只读取中文比对，只要就是比对名字，四个单元格两两比对，存在连续两个字相同的，结果赋值是，否则赋值否

FineReport 帆软用户NdPyJlXnUw 发布于 2025-7-11 11:13

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

snrtuemcLv8专家互助
发布于2025-7-11 11:15（编辑于 2025-7-11 11:15）

改成

=if(JOINARRAY(split(G8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(I8,"[^\\u4e00-\\u9FFF]"),"")||JOINARRAY(split(I8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(K8,"[^\\u4e00-\\u9FFF]"),"")||JOINARRAY(split(K8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(M8,"[^\\u4e00-\\u9FFF]"),""),"是","否")

=========

也可以OR写法

=if(or(JOINARRAY(split(G8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(I8,"[^\\u4e00-\\u9FFF]"),""),JOINARRAY(split(I8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(K8,"[^\\u4e00-\\u9FFF]"),""),JOINARRAY(split(K8,"[^\\u4e00-\\u9FFF]"),"")=JOINARRAY(split(M8,"[^\\u4e00-\\u9FFF]"),"")),"是","否")