主题：救教：指定输入数字和显示时间问题

egd文件下载

-=-=-=- 以下内容由 易表新学生 在 2012年04月08日 11:41pm 时添加 -=-=-=-
辛苦了各位！

[这个贴子最后由lyang70在 2012/04/09 10:09am 第 1 次编辑]

解决了时间显示问题，至于特定数值输入楼主能否说具体些，诸如：是否不能输入含“0”的数值？是否数值必须是大于0小于10的整数？数值之间是否都由一个空格？

忘了传文件：egd文件下载

当选择逻辑列后，显示时间为当前的 年、月、日、时、分 如：1012-4-9 9：55

-=-=-=- 以下内容由 易表新学生 在 2012年04月09日 10:45am 时添加 -=-=-=-
谢谢你！lyang70 ，日期时间已经解决了。指定输入数字有办法解决吗？不含“0”只能输入 1 2 3 4 5 6 7 8 9 其它的都不能写入。

汉字也不能输入？范围太大啦！

换个思路，通过录入窗口解决吧！
egd文件下载

egd文件下载

[这个贴子最后由wjq1072在 2012/04/09 05:58pm 第 1 次编辑]

呵呵仅去掉英文字母、汉字。而且对字符数量还有一定的限制！
刷新公式就巨无霸啦！？

Eval("If(Len(Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",1))=1,Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",1)+"" "","""")")+Eval("If(Len(Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+"""))))"),"  ",""))+""","" "",2))=1,Split("""+Text(Substitute(Eval("Trim(format("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|o|p|q|r|s|t|u|v|w|x|y|z","|",""",""""),""")+""","""")"),"0",""))+""",rept(""@ "",Len("""+Text(Substitute(Eval(Rept("Substitute(",52)+"[上架],"""+Substitute("A|B|C|D|E|F|G|H|I|J|K|L|M|N|P|O|Q|R|S|T|U|V|W|X|Y|Z|a|b|c|d|e|f|g|h|i|j|k|l|m|n|

呵呵… wjq1072 ，太厉害！非常感谢！

简化一下！
Substitute(Eval("If(Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),"+Substitute(Substitute(Eval("Substitute(""|@|"",""|"","""+Substitute("1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50","|",""")+""|""+Substitute(""|@|"",""|"",""")+""")"),"@","-1,1)="""","""",Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),"),"|","-1,1)+"" "")+If(Mid(Eval(Rept(""Substitute("",53)+""[上架],""""""+Substitute(""A\B\C\D\E\F\G\H\I\J\K\L\M\N\P\O\Q\R\S\T\U\V\W\X\Y\Z\a\b\c\d\e\f\g\h\i\j\k\l\m\n\o\p\q\r\s\t\u\v\w\x\y\z\0"",""\"","""""",""""""""),"""""")+"""""","""""""")""),")+"-1,1)+"" "")"),"  ","")

太好了，太厉害了，我要的就是这样，谢谢你了wjq1072