awk数据预处理

{
    if(NF==1 && $0~/192.168/)
        host_name = $0
    for(i=1;i<NF;++i) {
        if($i~/192.168/) {
            split($i, a, "=") 
            printf("%s, %s\n", host_name, a[2])
        }
} }

原始数据:

192.168.115.31
+--------------------------------------+-----------------+----------------------------------+--------+------------+-------------+------------------------+
| ID | Name | Tenant ID | Status | Task State | Power State | Networks |
+--------------------------------------+-----------------+----------------------------------+--------+------------+-------------+------------------------+
| 16223a2b-1f38-4a59-b364-e3671aa3182e | PBOSS_test-5 | 5e33cf661bb24d608fa443372283615e | ACTIVE | - | Running | net119=192.168.119.132 |
| 739fe351-e679-4ef3-8428-738250de7d16 | lt-gmlcyh07 | efe9941d051c4b10bc8994be37cf1241 | ACTIVE | - | Running | net119=192.168.119.52 |
| 03494fd2-befa-4113-89c8-44269ed5c7d5 | tysj-app-test02 | c4f12fb027a34a8d8a98dc3fccaf13fa | ACTIVE | - | Running | net119=192.168.119.230 |
| beefd53b-68d8-4f09-aeb8-9225c81a5e01 | zabbix | f14cd5cd06ed4dca9b166fe1236700a8 | ACTIVE | - | Running | net115=192.168.115.14 |
+--------------------------------------+-----------------+----------------------------------+--------+------------+-------------+------------------------+

结果如下:

192.168.115.31, 192.168.119.132
192.168.115.31, 192.168.119.52
192.168.115.31, 192.168.119.230
192.168.115.31, 192.168.115.14

posted @ 2019-04-10 15:57  东宫得臣  阅读(156)  评论(0编辑  收藏  举报