一堆杂乱无章的数,如何统计出现的次数,代码应如何写呢,请高手支招
…..各有1万条记录 DBF表----A1
-----------------------------------------------------------------
表名 | 参数
P0001 | 29,24,35,02,34,20,31,36,10,09,25,14,28,01,26,23,15,33,
P0002 | 08,19,20,11,01,02,35,03,16,23,27,34,32,29,25,30,12,22,
P0003 | 26,21,11,22,16,24,12,27,33,13,15,18,04,05,19,02,03,31,
P0004 | 29,34,32,27,07,16,01,25,08,30,22,18,35,23,31,11,06,12,
P0005 | 04,14,05,06,08,21,17,01,36,34,13,22,03,23,33,24,25,30,
...... 各有1万条记录
-----------------------------------------------------------------
现在需要从A1表中取出8张表来统计各数值出现的次数,代码应如何写呢,请高手支招。
需要的结论如下(举例):
8次: 20
5次:01,12,15
3次:03,04,09,23,29,33,35,36
2次:06,07,11,16,19
1次: …
0次:…