Log에서 데이터 추출3

윈도우에서 로그 파일을 검색하여 추출하고,
리눅스에서 grep, sed, awk를 사용하여 원하는 자료만 추출한다.

"mopumopu777",2620073,D,201232,"?業王",488204,221.186.67.218,221.186.67.218,52095,10, Item+,1,10012293,2,2,7,0,0,2,0,0,0,0000000000000000000000000000,0,0
"mopumopu777",2620073,D,201232,"?業王",488204,221.186.67.218,221.186.67.218,52095,10, AccountCargo-,38,10012293,0,2
"kartmania",2620140,D,201238,"ばななうゆ",406,221.186.67.218,221.186.67.218,54232,10, s_gob,1
"kartmania",2620140,D,201242,"ばななうゆ",406,221.186.67.218,221.186.67.218,54232,10, Money-,3594871,100,16
"kartmania",2620140,D,201242,"ばななうゆ",406,221.186.67.218,221.186.67.218,54232,10, MailS,"午後の紅茶",0,0,0
"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, Item-,1,10012263,98,1,10,98,0,0,0,0000000000000000000000000000,0,0
"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, PvPMission-,0,0
"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, ClearQP,1306,1306,0,0
"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, CP,8,3,1,2,1,1
"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, Skill+,8,5,1,1,-1
#---------------------------------------------------------------------------------------------------
findstr /S " Item+" *
history.log:"mopumopu777",2620073,D,201232,"?業王",488204,221.186.67.218,221.186.67.218,52095,10, Item+,1,10012293,2,2,7,0,0,2,0,0,0,0000000000000000000000000000,0,0

grep " Item+" test.log
history.log:"mopumopu777",2620073,D,201232,"?褻鞏",488204,221.186.67.218,221.186.67.218,52095,10, Item+,1,10012293,2,2,7,0,0,2,0,0,0,0000000000000000000000000000,0,0^M

grep " Item+" test.log | sed 's/".\{0,20\}",/,/g'
history.log:,2620073,D,201232,,488204,221.186.67.218,221.186.67.218,52095,10, Item+,1,10012293,2,2,7,0,0,2,0,0,0,0000000000000000000000000000,0,0^M

grep " Item+" test.log | sed 's/".\{0,20\}",/,/g' | sed 's/,0000000000000000000000000000,/,/g'
history.log:,2620073,D,201232,,488204,221.186.67.218,221.186.67.218,52095,10, Item+,1,10012293,2,2,7,0,0,2,0,0,0,0,0^M

grep " Item+" test.log | sed 's/".\{0,20\}",/,/g' | sed 's/,0000000000000000000000000000,/,/g' | awk -F[,] '{print $6,$12,$13,$14,$15,$16}'
488204 1 10012293 2 2 7
#---------------------------------------------------------------------------------------------------
findstr /S " Item-" *
history.log:"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, Item-,1,10012263,98,1,10,98,0,0,0,0000000000000000000000000000,0,0

grep " Item-" test.log >> resultp.log
history.log:"uw0220_1",2620107,D,201357,"???????",245,221.186.67.218,221.186.67.218,21187,10, Item-,1,10012263,98,1,10,98,0,0,0,0000000000000000000000000000,0,0

grep " Item-" test.log | sed 's/".\{0,20\}",//g' >> resultp.log
history.log:2620107,D,201357,245,221.186.67.218,221.186.67.218,21187,10, Item-,1,10012263,98,1,10,98,0,0,0,0000000000000000000000000000,0,0

grep " Item-" test.log | sed 's/".\{0,20\}",//g' | sed 's/,0000000000000000000000000000,/,/g' >> resultp.log
history.log:2620107,D,201357,245,221.186.67.218,221.186.67.218,21187,10, Item-,1,10012263,98,1,10,98,0,0,0,0,0

grep " Item-" test.log | sed 's/".\{0,20\}",//g' | sed 's/,0000000000000000000000000000,/,/g' | awk -F[,] '{print $4,$10,$11,$12,$13,$14}' >> resultp.log
245 1 10012263 98 1 10

grep " Item+" game20130104.txt | sed 's/".\{0,20\}",/,/g' | sed 's/,0000000000000000000000000000,/,/g' | awk -F[,] '{if($13==1253) print $6,$12,$13,$14,$15,$16}' > game20130104_p.txt
grep " Item-" game20130105.txt | sed 's/".\{0,20\}",//g' | sed 's/,0000000000000000000000000000,/,/g' | awk -F[,] '{if($14==19) print $4,$10,$11,$12,$13,$14}' > game20130105_m.txt