awk取字段 向大侠请教

ys547007

数据如下：
17:40:10:416315  [end task]:dispId:9,taskID:201,rowLen:100,shouldRowNum:6,actualRowNum:6,todayRowNum:1950,lastBeginTime:10-23_17:40:09:8482,lastEndTime:10-23_17:40:09:9722
17:40:11:428225  [end task]:dispId:6,taskID:241,rowLen:111,shouldRowNum:6,actualRowNum:6,todayRowNum:11700,lastBeginTime:10-23_17:40:09:6973,lastEndTime:10-23_17:40:09:8265
17:40:11:428361  [end task]:dispId:6,taskID:261,rowLen:111,shouldRowNum:14,actualRowNum:14,todayRowNum:27300,lastBeginTime:10-23_17:40:10:4717,lastEndTime:10-23_17:40:10:4978
17:40:16:483620  [end task]:dispId:6,taskID:241,rowLen:111,shouldRowNum:6,actualRowNum:6,todayRowNum:11706,lastBeginTime:10-23_17:40:14:5411,lastEndTime:10-23_17:40:14:5794
17:40:16:483740  [end task]:dispId:6,taskID:261,rowLen:111,shouldRowNum:14,actualRowNum:14,todayRowNum:27314,lastBeginTime:10-23_17:40:15:5334,lastEndTime:10-23_17:40:15:5813
17:40:16:483797  [end task]:dispId:7,taskID:181,rowLen:54,shouldRowNum:5,actualRowNum:5,todayRowNum:8130,lastBeginTime:10-23_17:40:15:6233,lastEndTime:10-23_17:40:15:7306

要取每行rowLen:后面的数字和todayRowNum：后的数字 请赐教！

ys547007

回复 18# jason680




    也就是说a[0]存的是正则表达式整个匹配字符串的值，a[1], a[2]存的是()内限定的匹配值 可以这样理解吗

jason680

回复 17# ys547007

http://www.gnu.org/software/gawk/manual/gawk.html#String-Functions

# echo 123foooobazbarrrrr123 | awk '{ match($0, /(fo+).+(bar*)/, a)
print "[0]="a[0] " [1]="a[1] " [2]="a[2]
print "0 Start=" a[0,"start"] ", Len="a[0,"length"]
print "1 Start=" a[1,"start"] ", Len="a[1,"length"]
print "2 Start=" a[2,"start"] ", Len="a[2,"length"]
}'
[0]=foooobazbarrrrr [1]=foooo [2]=barrrrr
0 Start=4, Len=15
1 Start=4, Len=5
2 Start=12, Len=7

   

ys547007

回复 10# jason680

#tail ssync_20131025.log |grep "end task" |awk 'function get_val(k){if(match($0,k"[^,]+)",a))return a[1]}{r=get_val("rowLen";t=get_val("actualRowNum";print r,t}'
100 6
111 6
111 14
111 6
111 14
#tail ssync_20131025.log |grep "end task" |awk 'function get_val(k){if(match($0,k"[^,]+)",a))return a[0]}{r=get_val("rowLen";t=get_val("actualRowNum";print r,t}'
rowLen:100 actualRowNum:6
rowLen:111 actualRowNum:6
rowLen:111 actualRowNum:14
rowLen:111 actualRowNum:6
rowLen:111 actualRowNum:14
敢问大神 数组a存值是怎么个存法 a[0]得到的是rowLen:100 actualRowNum:6 而a[1]就只是数字 100 6

reb00t

grep  -oP '(?<='rowLen:')\d+|(?<='todayRowNum:')\d+' a.txt |sed 'N;s/\n/ /g'

elu_ligao

awk 'BEGIN{FS="rowLentodayRowNum:"}{printf("%d\t%d\n", +$2, +$3)}'  file

LikeLx

回复 12# wang390750
3楼的方法，你看看，遇到关键词的时候才进行处理，不论你怎么增加和减少，只要有关键词就可以抓取出来！

   

ys547007

谢谢各位大牛  问题已解决

wang390750

回复 9# LikeLx


    我也在考虑这个问题。。
现在有个问题请教一下  awk -F "[ \t,:]+" '/rowLen/ && /todayRowNum/{print $12,$18}' 1
如何替换$12 和 $18呢。

noshell

顶一个不错，回复 7# trdcaz