如何从包含表格数据的文件中提取第一列和第二列

Question

考虑以下文件，以表格格式保存网络客户端数据：

                <H2>Welcome to CCcam 2.1.3 server </H2>
            Connected clients: 75
            +------------+---------------+------------+------------+-----------+-----+--------+----------------------------------------------+----------+
            | Username   | Host          | Connected  | Idle time  | ECM       | EMM | Version| Last used share                              | Ecm time |
            +------------+---------------+------------+------------+-----------+-----+--------+----------------------------------------------+----------+
    |user4       |1x3.xxx.126.xx |00d 22:53:52|00d 22:53:52|0 (0)      |0 (0)|2.1.3   |                                              |          |
    |useral      |7x.xx.xxx.1xx  |00d 22:53:52|00d 22:53:52|0 (0)      |0 (0)|2.0.11  |                                              |          |
    |userxxxx    |x7.xx5.xx.1x1  |00d 22:53:52|00d 22:53:52|0 (0)      |0 (0)|2.0.11  |                                              |          |
    |someuse     |9x.8x.xx0.xx4  |00d 22:53:52|00d 00:00:15|8248 (8245)|0 (0)|2.1.4   |UPC 1W - Zone Reality Europe [CW2] (ok)       |  0.3060s |
    |nameuse     |x8.xx3.6x.7x   |00d 22:53:51|00d 22:53:51|0 (0)      |0 (0)|2.2.1   |                                              |          |
    |blabl       |xx.2xx.x.x4    |00d 22:53:50|00d 00:00:00|4282 (2541)|0 (0)|2.1.4   |Total TV - Fox TV Serbia [NDS] (ok)           |  0.1099s |
    |aaaaaa      |xx9.x3.4x.2x   |00d 22:53:49|00d 00:56:41|1753 (1536)|0 (0)|2.1.4   |Total TV - OBN [NDS] (nok)                    |  0.1264s | 

+------------+---------------+------------+------------+-----------+-----+--------+----------------------------------------------+----------+

    +------------+---------------------------------------+
    | Username   | Shareinfo                             |
    +------------+---------------------------------------+
    |       user3|                                       |
    |      user33|                                       |
    |    user2222|                                       |
    |     user333|local 0d02:000000 6589(6588)           |
    |            |remote 0d02:000000 756(755)            |
    |            |remote 1802:000000 853(852)            |
    |            |local 1802:000000 50(50)               |
    |     user444|                                       |
    |       user3|local 091f:000000 2154(2147)           |
    |            |remote 091f:000000 394(394)            |
    |            |local 1802:000000 1734(0)              |
    |      USER22|local 091f:000000 1677(1509)           |
    |            |local 0d02:000000 4(3)                 |
    |            |local 1802:000000 70(22)               |
    |            |remote 091f:000000 1(1)                |
    |            |remote 1802:000000 1(1)                |
    |       USER1|local 0d02:000000 3359(3357)           |
    |            |remote 0d02:000000 165(165)            | 
    +------------+---------------------------------------+

我们如何提取该文件的前两列，即字段 user 和 ip address，因此该输出将如下所示：

user4  1x3.xxx.126.xx
useral 7x.xx.xxx.1xx 
userxxxx x7.xx5.xx.1x1 
someuse 9x.8x.xx0.xx4  
nameuse x8.xx3.6x.7x
blabl xx.2xx.x.x4    
aaaaaa xx9.x3.4x.2x     

Answer 1

BEGIN { FS = "|" }

/Last used share/ { next }

{ if(NF == 11) print $2, $3 }

---

更新：操作说明...

$ awk -f test.awk < cam.txt
user4        1x3.xxx.126.xx 
useral       7x.xx.xxx.1xx  
userxxxx     x7.xx5.xx.1x1  
someuse      9x.8x.xx0.xx4  
nameuse      x8.xx3.6x.7x   
blabl        xx.2xx.x.x4    
aaaaaa       xx9.x3.4x.2x   

或者，someprogram | awk -f 测试.awk

Answer 2

我建议应用问题“如何使用 shell 脚本解析机架空间大数据 api 响应”的答案中开发的技术在您的特殊情况下，这会产生：

# ccam_canonize
#  Canonize output of ccam report tools
ccam_canonize()
{
  sed -e '1,3d;/^+[-+]*$/d;s/^| //;s/ |$//;s/ | /|/g;/Shareinfo/,$d'
}

# ccam_extract
#  Extract user and IP
ccam_extract()
{
  awk -F'|' '{print($1,$2)}'
}

ccam_canonize | ccam_extract