- 论坛徽章:
- 1
|
我这边有两个文件18656536338_fdr_2145.txt， 18656536338_logcdr_092145.txt
想从18656536338_fdr_2145.txt 文件中过滤掉 18656536338_logcdr_092145.txt 中的第八个字段不存在于第一个文件的第14个字段的记录？
文件如下：
[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]# |
|
免费注册
发表于 2014-01-11 00:01
