一个shell的问题_sort

wbbshen

我有一个文件,内容是这个样子的
list_mac-ip.txt
  IP ADDRESS = 192.168.2.236 ;
  MAC ADDRESS= 00:21:70:ee:86:f3;

  IP ADDRESS = 192.168.2.250 ;
  MAC ADDRESS= 00:0c:29:ac:29:3f;

  IP ADDRESS = 192.168.2.172 ;
  MAC ADDRESS= 00:23:7d:11:69:27;

  IP ADDRESS = 192.168.2.175 ;
  MAC ADDRESS= 00:0c:29:64:5f:b8;

  IP ADDRESS = 192.168.2.209 ;
  MAC ADDRESS= 00:24:e8:ad:e2:b2;

  IP ADDRESS = 192.168.2.199 ;
  MAC ADDRESS= 00:21:70:72:24:53;

  IP ADDRESS = 192.168.2.166 ;
  MAC ADDRESS= e4:1f:13:6c:4b:a8;

  IP ADDRESS = 192.168.2.163 ;
  MAC ADDRESS= 00:24:e8:c6:f2:3f;

  IP ADDRESS = 192.168.2.193 ;
  MAC ADDRESS= 00:0c:29:ac:29:3f;

  IP ADDRESS = 192.168.2.246 ;
  MAC ADDRESS= 00:0c:29:f0:95:ce;

  IP ADDRESS = 192.168.2.165 ;
  MAC ADDRESS= 00:0c:29:67:72:9c;

  IP ADDRESS = 192.168.2.243 ;
  MAC ADDRESS= 00:0c:29:67:72:9c;

  IP ADDRESS = 192.168.2.243 ;
  MAC ADDRESS= 00:0c:29:67:72:9c;

我要把其中的相同字段合并,但格式不变化;
我用cat list_mac_ip.txt |sort -u
命令结果:类似这样:
IP ADDRESS = 192.168.2.240 ;
  IP ADDRESS = 192.168.2.241 ;
  IP ADDRESS = 192.168.2.242 ;
  IP ADDRESS = 192.168.2.243 ;
  IP ADDRESS = 192.168.2.244 ;
  IP ADDRESS = 192.168.2.245 ;
  IP ADDRESS = 192.168.2.246 ;
  IP ADDRESS = 192.168.2.247 ;
  IP ADDRESS = 192.168.2.248 ;
  IP ADDRESS = 192.168.2.249 ;
  IP ADDRESS = 192.168.2.250 ;
  IP ADDRESS = 192.168.2.84 ;
  MAC ADDRESS= 00:0b:cd:9a:a5:8d;
  MAC ADDRESS= 00:0c:29:01:99:d8;
  MAC ADDRESS= 00:0c:29:03:eb:89;
  MAC ADDRESS= 00:0c:29:09:c6:37;
  MAC ADDRESS= 00:0c:29:0c:82:e9;
  MAC ADDRESS= 00:0c:29:19:17:5d;
  MAC ADDRESS= 00:0c:29:1e:00:be;
  MAC ADDRESS= 00:0c:29:22:85:93;
  MAC ADDRESS= 00:0c:29:23:45:5a;
  MAC ADDRESS= 00:0c:29:24:ea:16;
  MAC ADDRESS= 00:0c:29:27:aa:9b;
  MAC ADDRESS= 00:0c:29:29:68:c0;
  MAC ADDRESS= 00:0c:29:2b:c7:78;
  MAC ADDRESS= 00:0c:29:3f:be:03;
  MAC ADDRESS= 00:0c:29:45:e5:72;
  MAC ADDRESS= 00:0c:29:47:da:b7;
  MAC ADDRESS= 00:0c:29:47:f3:fb;

把同字段合并了,
但格式却变化了,各位大虾,有没有什么办法解决???

wbbshen

在线等,

ywlscpl

你想要怎样？
没说清楚嘛

wbbshen

我要把原文件中的相同字段合并,但格式不变化;
比如:
IP ADDRESS = 192.168.2.243 ;
  MAC ADDRESS= 00:0c:29:67:72:9c;

  IP ADDRESS = 192.168.2.243 ;
  MAC ADDRESS= 00:0c:29:67:72:9c;
合并后,只显示一个,但格式不变
还是IP和MAC在一起的

ywlscpl

这样

1. awk '/IP/{ip=$4;getline v;a[ip]=$0"\n"v"\n"}END{for (i in a) print a[i]}' file

复制代码

1. [root@Mylinux tmp]# awk '/IP/{ip=$4;getline v;a[ip]=$0"\n"v"\n"}END{for (i in a
   
2. ) print a[i]}' file
   
3.   IP ADDRESS = 192.168.2.163 ;
   
4.   MAC ADDRESS= 00:24:e8:c6:f2:3f;
   
5. 
   
6.   IP ADDRESS = 192.168.2.172 ;
   
7.   MAC ADDRESS= 00:23:7d:11:69:27;
   
8. 
   
9.   IP ADDRESS = 192.168.2.250 ;
   
10.   MAC ADDRESS= 00:0c:29:ac:29:3f;
    
11. 
    
12.   IP ADDRESS = 192.168.2.165 ;
    
13.   MAC ADDRESS= 00:0c:29:67:72:9c;
    
14. 
    
15.   IP ADDRESS = 192.168.2.243 ;
    
16.   MAC ADDRESS= 00:0c:29:67:72:9c;
    
17. 
    
18.   IP ADDRESS = 192.168.2.193 ;
    
19.   MAC ADDRESS= 00:0c:29:ac:29:3f;
    
20. 
    
21.   IP ADDRESS = 192.168.2.166 ;
    
22.   MAC ADDRESS= e4:1f:13:6c:4b:a8;
    
23. 
    
24.   IP ADDRESS = 192.168.2.175 ;
    
25.   MAC ADDRESS= 00:0c:29:64:5f:b8;
    
26. 
    
27.   IP ADDRESS = 192.168.2.209 ;
    
28.   MAC ADDRESS= 00:24:e8:ad:e2:b2;
    
29. 
    
30.   IP ADDRESS = 192.168.2.236 ;
    
31.   MAC ADDRESS= 00:21:70:ee:86:f3;
    
32. 
    
33.   IP ADDRESS = 192.168.2.246 ;
    
34.   MAC ADDRESS= 00:0c:29:f0:95:ce;
    
35. 
    
36.   IP ADDRESS = 192.168.2.199 ;
    
37.   MAC ADDRESS= 00:21:70:72:24:53;
    
38. 
    
39. [root@Mylinux tmp]#

复制代码

wbbshen

awk很强啊...谢谢楼上

wbbshen

回复 5# ywlscpl


    为什么输入的时候,有的是IP address 在前面,有的是MAC address在前面

格式能否保留每个IP address 和mac address是匹配 然后每两个用空行分开?

wbbshen

谢谢 ,ywlscpl (白云苍狗)
回头再去研究一下awk

ywlscpl

回复 8# wbbshen


    因为  IP ADDRESS = 192.168.2.250 ;
  MAC ADDRESS= 00:0c:29:ac:29:3f;

和  IP ADDRESS = 192.168.2.193 ;
  MAC ADDRESS= 00:0c:29:ac:29:3f;


MAC地址相同，如果针对行去重的，第2个MAC地址这行不打印

所以要看你需求，是针对ip去重，还是mac去重。如果是后者，我那条语句还要改

1. awk '/IP/{v=$0;getline;a[$3]=v"\n"$0"\n"}END{for (i in a) print a[i]}' file

复制代码

保留最后那个MAC出现的那段