日志中指定行合并 大虾多多请教呀

nakalzz

回复 6# dn833

请问一下能否把下面格式稍微改变一下
现在

Project_A  20120901 10:01:13 start  20120902 00:01:13 end
Project_A  20120902 10:01:13 start  20120903 00:01:13 end

改编后


Project_A,  20120901 10:01:13, start,  20120902 00:01:13, end
Project_A,  20120902 10:01:13, start,  20120903 00:01:13, end


   

jason680

回复 10# nakalzz

Try it to modify

nakalzz

回复 12# jason680


我这个修改的好像可以了 谢谢
不知道有没有什么可以改进的
    awk -v a=$FNAME '$1~/^'$FNAME'$/{gsub(/:/,", ");printf($NF~/^started$/)?$0"\t":" "$2" "$3" "$4"\n"}'

nakalzz

#!/bin/csh
rm -f joblog.csv
foreach FNAME_FULL (`ls -1 *log`)
set FNAME =  $FNAME_FULL:r
awk -v a=$FNAME '$1~/^'$FNAME'$/{gsub(/ : /,", ");printf($NF~/^started$/)?$0:", "$2" "$3" "$4"\n"}' $FNAME_FULL >> joblog.csv
end


结果
Pro1, 20100823 9:03:01, started, 20100823 9:03:01, completed
Pro2, 20100824 9:03:02, started, 20100824 9:03:02, completed
Pro3, 20100825 9:03:03, started, 20100825 9:03:03, completed
Pro4, 20100826 9:03:04, started, 20100826 9:03:04, completed

dn833

这不挺好的嘛。。。。。。饭都已经送到嘴边了

cjaizss

nakalzz 发表于 2012-09-09 08:10
回复 8# jason680

输出前再加一个{}
里面写
fo(i=2;i<=NF;i++)
      if($i=="start"||$i=="end")
                $(i-1)=$(i-1)",";