说明：
1文件格式：id,a,b,c(a,b,c为三列数值）
2文件格式：类别,起始id,截止id
目的：
根据2文件中类别的起止id，分别算出a,b,c三列的最大值，最小值
结果文件格式：
类别,a最大值,b最大值,c最大值,,a最小值,b最小值,c最小值
1文件
  
2文件


结果文件：
nv01,0.192,0.256 ,0.303 ,,-0.165,-0.139,0.023
nv02,0.164,0.140 ,0.217 ,,-0.199,-0.152,0.023
nv03,0.052,0.038 ,0.124 ,,-0.100,-0.074,0.038
nv04,0.138,-0.021 ,0.157,,0.029 -0.106,0.067
nv05,0.161,0.149 ,0.170 ,,-0.156,-0.117,0.060




[ 本帖最后由 xinshous 于 2010-2-24 09:52 编辑 ]

谢谢，完全符合要求
思路清晰明朗

为何我将第一行数值改为
100,23,12,-13
结果还是
nv01,0.192,0.256,0.303, ,-0.165,-0.139,0.023
nv02,0.164,0.139,0.217, ,-0.199,-0.152,0.023
nv03,0.074,0.152,0.155, ,-0.1,-0.101,0.028
nv04,0.138,-0.021,0.157, ,0.064,-0.074,0.067
nv05,0.161,0.149,0.161, ,-0.156,-0.117,0.06

最大值，最小值都不对了呀？

明白了，我也忽略了，谢谢
我改成>=  and <=就可以了
可是我加一行
100,23,12,-13
100,10,28,45,-998
101,-0.043 ,-0.122 ,0.129
102,0.145 ,0.099 ,0.176

结果：
nv01,23.,28.,45., ,-0.165,-0.139,-13.
23，28，45都挑对了，－998却没挑出来，不知为何
初学者，还请见教

100,23,12,-13
100,28,45,-998
101,-0.043 ,-0.122 ,0.129
102,0.145 ,0.099 ,0.176
103,-0.049 ,0.000 ,0.049
104,0.104 ,-0.081 ,0.132
105,-0.025 ,-0.050 ,0.056
106,0.044 ,0.086 ,0.097
107,0.192 ,0.007 ,0.192
108,0.127 ,0.017 ,0.128
109,-0.165 ,0.075 ,0.181
110,0.023 ,0.000 ,0.023
结果变成如下了，还请关注
nv01,-9999999.,-9999999.,-9999999., ,9999999.,9999999.,9999999.
nv02,-9999999.,-9999999.,-9999999., ,9999999.,9999999.,9999999.
nv03,-9999999.,-9999999.,-9999999., ,9999999.,9999999.,9999999.
nv04,-9999999.,-9999999.,-9999999., ,9999999.,9999999.,9999999.
nv05,-9999999.,-9999999.,-9999999., ,9999999.,9999999.,9999999.

谢谢 风吹过b老师
您不厌其烦的指导
及其高深的内在修养
让我受益匪浅
谢谢了
明天我将做深入检查
不便之处还请见谅

1052,0.106,-0.089,0.138
1052,3.294,0.092,3.295
1052,-0.183,0.14,0.23
1052,-0.001,-0.213,0.213
1052,-0.161,0.07,0.176
1052,1.56,0.087,1.562
1052,3.94,-0.011,3.94
1052,0.173,-0.041,0.178
1052,0.133,-0.102,0.168
1052,-7.545,-0.012,7.545
1052,-0.013,-0.081,0.082
1052,-0.01,-0.193,0.193
1052,0.118,0.157,0.196
1052,-0.03,-0.18,0.182
1052,0.15,-0.054,0.159
1052,0.095,0.105,0.142

2文件
nv01,1046,1091
nv02,1049,1094
nv03,1052,1097
nv04,1055,1100

1052,-7.545这个值应该nv01、nv02、nv03都能体现
可结果是
nv01,6.877,3.367,7.547, ,-7.546,-2.808,0.001
nv02,4.569,2.979,4.969, ,-4.969,-0.39,0.014
nv03,4.806,0.371,4.807, ,-4.765,-0.324,0.005
nv04,4.372,5.326,6.653, ,-6.652,-0.374,0.011
不知为何？
另外可否传出两种结果
一种是现在的最大最小
一种是不管正负
谁差值大取谁
如最大值－7和＋6，取－7
最小值，－3和1，取1
多次打扰，内心惶恐
不便之处请见谅
传上完整附件，请查看
谢谢

风吹过b老师您好，多次打搅深感不安
nv01,1046,1091
nv02,1049,1094
nv03,1052,1097
nv04,1055,1100

nv01,nv02,nv03都包含1052
可是1052,0.133,-0.102,0.168
    1052,-7.545,-0.012,7.545
    1052,-0.013,-0.081,0.082

可是    1052,-7.545,-0.012,7.545
却未出现在结果nv02,nv03中
还请老师您再看一下


结果文件：
nv01,6.877,3.367,7.547, ,-7.546,-2.808,0.001
nv02,4.569,2.979,4.969, ,-4.969,-0.39,0.014
nv03,4.806,0.371,4.807, ,-4.765,-0.324,0.005
nv04,4.372,5.326,6.653, ,-6.652,-0.374,0.011

nv01,-7.546,3.367,7.547, ,0.0,0.0,0.001
nv02,-4.969,2.979,4.969, ,0.0,-0.001,0.014
nv03,4.806,0.371,4.807, ,-0.001,0.001,0.005
nv04,-6.652,5.326,6.653, ,0.001,0.0,0.011

[ 本帖最后由 xinshous 于 2010-2-23 10:21 编辑 ]

重新提供附件

真是太感谢了
多次打扰
真的很是抱歉
剩下的我想加两个文本框
取在这区间的最大值、最小值
仍是要两种结果
初学者可能会费点劲
但实在不好意思再麻烦了风吹过b老师了
如能有老师原滋原味的后续也更好
值此受益已是非浅
谢谢