用户社区-[求助]Eval()用法易表在线答疑 - 简单实用的数据管理软件|数据统计软件|数据分析软件|电子表格软件

以文本方式查看主题

-  易表在线答疑  (http://egrid2000.com/dvbbs/index.asp)
--  用户社区  (http://egrid2000.com/dvbbs/list.asp?boardid=2)
----  [求助]Eval()用法  (http://egrid2000.com/dvbbs/dispbbs.asp?boardid=2&id=26773)

--  作者：iyplx2425
--  发布时间：2013/12/9 21:09:00
--  [求助]Eval()用法
有下面公式：
CountFor(GridName,Right([红

1],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红

2],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红

3],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红

4],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红

5],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红

6],1), "=" ,[杀1],"期号", "=" ,[期号])

我用

Eval("CountFor(GridName,Right([红" +Substitute("1|2|3|4|5|6","|","],1), "=" ,[杀1],"期号", "=" ,[期号]) + CountFor(GridName,Right([红 ")+ "],1), "=" ,[杀1],"期号", "=" ,[期号])")

来替代，但提示语法错误。是不是双引号用得不对？请指教。谢谢！

--  作者：wjq1072
--  发布时间：2013/12/10 8:55:00
--
Eval("CountFor(GridName,Right([红"+Substitute("1|2|3|4|5|6","|","],1),""="",[杀1],""期号"",""="",[期号])+CountFor(GridName,Right([红")+"],1),""="",[杀1],""期号"",""="",[期号])")

--  作者：dancedy
--  发布时间：2013/12/10 9:27:00
--
Eval("CountFor(GridName,""红" + Substitute("1|2|3|4|5|6","|",""",""like"",""*""+[杀1],""期号"",""="",[期号]) + CountFor(GridName,""红")+ """,""like"",""*""+[杀1],""期号"",""="",[期号])")

--  作者：客人
--  发布时间：2013/12/10 14:52:00
--
谢谢老师。先试试看。