论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2009-09-01 21:15 |只看该作者 |倒序浏览

5可用积分

一个目录下有多个要被处理的XLS文件，大概80个左右，每个文件大概4M左右。
[root@Fedora faxnum]# ls *.xls
20090501_2009053101.xls  20090601_2009063042.xls  20090701_2009073106.xls
20090501_2009053102.xls  20090601_2009063043.xls  20090701_2009073107.xls
20090501_2009053103.xls  20090601_2009063051.xls  20090701_2009073108.xls
20090501_2009053104.xls  20090601_2009063052.xls  20090701_2009073109.xls
20090501_2009053105.xls  20090631_2009063001.xls  20090701_2009073110.xls
20090501_2009053106.xls  20090631_2009063004.xls  20090701_2009073111.xls
20090501_2009053107.xls  20090631_2009063005.xls  20090701_2009073112.xls
20090501_2009053108.xls  20090631_2009063006.xls  20090701_2009073113.xls
20090501_2009053109.xls  20090631_2009063007.xls  20090701_2009073114.xls
20090501_2009053110.xls  20090631_2009063008.xls  20090701_2009073115.xls
20090501_2009053111.xls  20090631_2009063009.xls  20090701_2009073116.xls
20090601_2009063001.xls  20090631_2009063010.xls  20090701_2009073131.xls
20090601_2009063002.xls  20090631_2009063011.xls  20090701_2009073132.xls
20090601_2009063003.xls  20090641_2009063003.xls  20090701_2009073133.xls
20090601_2009063004.xls  20090701_2009072401.xls  20090701_2009073134.xls
20090601_2009063005.xls  20090701_2009072402.xls  20090731_2009073101.xls
20090601_2009063006.xls  20090701_2009072403.xls  20090731_2009073102.xls
20090601_2009063007.xls  20090701_2009072404.xls  20090731_2009073103.xls
20090601_2009063008.xls  20090701_2009072405.xls  20090731_2009073104.xls
20090601_2009063009.xls  20090701_2009072406.xls  20090801_2009082828.xls
20090601_2009063010.xls  20090701_2009072407.xls  20090801_2009082831.xls
20090601_2009063011.xls  20090701_2009072408.xls  20090801_2009083101.xls
20090601_2009063012.xls  20090701_2009072409.xls  20090801_2009083102.xls
20090601_2009063013.xls  20090701_2009073101.xls  20090801_2009083103.xls
20090601_2009063031.xls  20090701_2009073102.xls  20090801_2009083104.xls
20090601_2009063032.xls  20090701_2009073103.xls  20090801_2009083105.xls
20090601_2009063033.xls  20090701_2009073104.xls  20090801_2009083131.xls
20090601_2009063034.xls  20090701_2009073105.xls  20090801_2009083132.xls

我写一个shell脚本如下，
[root@Fedora faxnum]# cat num.sh
#!/bin/sh
for ((i = 1; i < 86; i++))
do
awk '{if(($7>"00:00:25" && $7<"00:01:30")) print $4}' 20090[0-9][0-9][0-9]_20090[0-9][0-9][0-9][0-9][0-9].xls >$i.txt
done
unix2dos $i.txt

[root@Fedora faxnum]# ./num.sh

这个命令在本机上处理速度很慢，大概要20-30分钟才可以执行完，
个人觉得主要是在20090[0-9][0-9][0-9]_20090[0-9][0-9][0-9][0-9][0-9].xls 这个正则表达式匹配文件名处理过程慢导致的，
明天上来看看，期待各位兄弟姐妹提供下好的方法和建议，提高下文件处理的速度。谢谢！

[ 本帖最后由 leezer 于 2009-9-1 21:17 编辑 ]