亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Chinaunix

標(biāo)題: 兩個(gè)文件之間的過濾 [打印本頁]

作者: yuloveban 時(shí)間: 2014-01-11 00:01
標(biāo)題: 兩個(gè)文件之間的過濾
我這邊有兩個(gè)文件18656536338_fdr_2145.txt， 18656536338_logcdr_092145.txt
想從18656536338_fdr_2145.txt 文件中過濾掉 18656536338_logcdr_092145.txt 中的第八個(gè)字段不存在于第一個(gè)文件的第14個(gè)字段的記錄？

文件如下：
[root@Zhengwu_merge 18656536338_2014010922]# head 18656536338_logcdr_092145.txt
18656536338|2014-01-09 21:46:11|2014-01-09 21:46:16|2014-01-09 21:46:11|10.14.16.231|58.243.250.141|43741|123.235.33.22|80|http://wireless.mapbar.com/rever ... ing.json?q=bblefelm,afbgefmb&gb=02&ch=GBK&rn=5&nq=2&format=true
18656536338|2014-01-09 21:45:56|2014-01-09 21:46:06|2014-01-09 21:45:56|10.14.16.231|58.243.250.141|62314|202.108.23.233|8000|http://im.tieba.baidu.com:8000/
18656536338|2014-01-09 21:45:52|2014-01-09 21:45:54|2014-01-09 21:45:52|10.14.16.231|58.243.250.141|63542|111.206.37.24|80|http://sdk.imap.baidu.com/sdk/v? ... r=1&screen=(480,800)&dpi=(240,240)&ctm=1389275135837&name=%E6%89%8B%E6%9C%BA%E8%90%A5%E4%B8%9A%E5%8E%85
18656536338|2014-01-09 21:45:55|2014-01-09 21:46:15|2014-01-09 21:45:55|10.14.16.231|58.243.250.141|11228|123.125.38.250|80|http://api.m.renren.com/api/batch/run
18656536338|2014-01-09 21:46:02|2014-01-09 21:46:05|2014-01-09 21:46:02|10.14.16.231|58.243.250.141|29779|202.108.23.85|80|http://hmma.baidu.com/app.gif
18656536338|2014-01-09 21:46:15|2014-01-09 21:46:22|2014-01-09 21:46:15|10.14.16.231|58.243.250.141|43742|123.235.33.22|80|http://wireless.mapbar.com/rever ... ing.json?q=bblefelm,afbgefmb&gb=02&ch=GBK&rn=5&nq=2&format=true
18656536338|2014-01-09 21:46:13|2014-01-09 21:46:15|2014-01-09 21:46:13|10.14.16.231|58.243.250.141|48425|123.125.65.115|80|http://loc.map.baidu.com/sdk.php
18656536338|2014-01-09 21:46:31|2014-01-09 21:46:34|2014-01-09 21:46:31|10.14.16.231|58.243.250.141|10311|60.217.241.30|80|http://wireless.mapbar.com/posit ... awde&idx=10
18656536338|2014-01-09 21:47:35|2014-01-09 21:47:38|2014-01-09 21:47:35|10.14.16.231|58.243.250.141|48440|123.125.65.115|80|http://loc.map.baidu.com/sdk.php
18656536338|2014-01-09 21:48:02|2014-01-09 21:48:04|2014-01-09 21:48:02|10.14.16.231|58.243.250.141|28412|60.217.232.164|80|http://wireless.mapbar.com/posit ... JggD&idx=12

[root@Zhengwu_merge 18656536338_2014010922]# head 18656536338_fdr_2145.txt
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:51.5385150|2014-01-09 21:45:51.5398460|1|68|132|200|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||4758|53|0||sdk.imap.baidu.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:53.6185280|2014-01-09 21:45:53.6199780|1|67|387|454|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||21874|53|0||talk.m.renren.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:54.5791480|2014-01-09 21:45:54.5806720|1|68|112|180|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||49143|53|0||im.tieba.baidu.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:54.9591590|2014-01-09 21:45:54.9605980|1|66|156|222|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||50770|53|0||api.m.renren.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:55.4400440|2014-01-09 21:45:55.4413880|1|64|99|163|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||27035|53|0||api.k.sohu.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:55.9389530|2014-01-09 21:45:55.9402830|1|76|148|224|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||20169|53|0||agentchannel.api.duapp.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:56.0024280|2014-01-09 21:45:56.0040020|1|67|131|198|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||23615|53|0||monitor.uu.qq.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:45:59.7191570|2014-01-09 21:45:59.7207180|1|62|110|172|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||52284|53|0||oc.umeng.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:46:01.2988520|2014-01-09 21:46:01.3002600|1|64|108|172|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||39821|53|0||hmma.baidu.com (A)(Host address)
18656536338|21764|21672|351858054419270|912|2014-01-09 21:46:01.3182010|2014-01-09 21:46:01.3204560|1|69|180|249|2|10.14.16.231|58.242.2.2|0||3gnet|460015455636266|220.206.178.49|220.206.178.77||21044|53|0||wireless.mapbar.com (A)(Host address)
[root@Zhengwu_merge 18656536338_2014010922]#

作者: 關(guān)陰月飛 時(shí)間: 2014-01-11 01:11
回復(fù) 1# yuloveban

目測一下：

awk 'FNR==NR{a[$8]=1;next}a[$14]' 18656536338_logcdr_092145.txt 18656536338_fdr_2145.txt

復(fù)制代碼

作者: bikong0411 時(shí)間: 2014-01-11 07:49
目測樓上目測的對

歡迎光臨 Chinaunix (http://72891.cn/)