[这个贴子最后由Ltdz在 2007/03/11 00:45pm 第 2 次编辑]
俺也试试:
egd文件下载修正“调发识别”列的公式(也可把此公式用在调发货物列的操作公式中,则可不用调发识别列):
If(Eval(Eval("""if(search("""",""""+""""""+Split(Substitute([调发货物],""-"","",""),"","" ," + Substitute(Substitute(Substitute(Substitute(Eval("Substitute(""|@|#|$|"",""|"","""+Substitute( Left([%YSLB%],3 * (len([调发货物]) -len(Substitute(Substitute([调发货物],",",""),"-",""))+1)-1),"|",""")+""|""+Substitute(""|@|#|$|"",""|"",""")+""")"),"@",")+"""""" + """","""",""""""+[%gs2%]+"""""")>=0 Or"" +Split(Substitute([调发货物],""-"","",""),"","" ,"),"#",")+ "">="" + Substitute(Substitute([%gs3%],"","","" or""+Split(Substitute([调发货物],""-"","",""),"","" ,"),"$",")+ "">=""),""-"","" and "" + Split(Substitute([调发货物],""-"","",""),"","" ,"),"|",")+""<="")+"",1,0)+if(search("""",""""+""""""+Split(Substitute([调发货物],""-"","",""),"","" ,") + ")+""<="")+"",1,0)""")) <> len([调发货物]) -len(Substitute(Substitute([调发货物],",",""),"-",""))+1,"调发货物超出待发货物范围!","")