AWK中取列是“$”+列号,据此要实现列的去留,
可以利用内置变量NF(Number of Field):当前行的字段的个数,即当前行被分割成了几列
使用“$NF”即可取到最后一列,也可以运算“$(NF-1)”取倒数第二列。
如果要删除某一列,则可以在输出前把目标列赋值为空串
获取指定列
[root@rabbit-api-001 test]
total 536
-rw-r--r-- 1 root root 12 Apr 30 13:58 a.txt
-rw-r--r-- 1 root root 12 Apr 30 13:58 b.txt
drwxr-xr-x 10 root root 328 Apr 29 10:28 djmockserver
-rw-r--r-- 1 root root 529365 Apr 28 21:25 djmockserver.zip
-rw-r--r-- 1 root root 241 Apr 28 07:57 select.sh
-rw-r--r-- 1 root root 42 Apr 28 20:34 test.txt
[root@rabbit-api-001 test]
536
a.txt
b.txt
djmockserver
djmockserver.zip
select.sh
test.txt
[root@rabbit-api-001 test]
total 536
13:58 a.txt
13:58 b.txt
10:28 djmockserver
21:25 djmockserver.zip
07:57 select.sh
20:34 test.txt
删除指定列
[root@rabbit-api-001 test]
total 536
-rw-r--r-- 1 root root 12 Apr 30 13:58 a.txt
-rw-r--r-- 1 root root 12 Apr 30 13:58 b.txt
drwxr-xr-x 10 root root 328 Apr 29 10:28 djmockserver
-rw-r--r-- 1 root root 529365 Apr 28 21:25 djmockserver.zip
-rw-r--r-- 1 root root 241 Apr 28 07:57 select.sh
-rw-r--r-- 1 root root 42 Apr 28 20:34 test.txt
[root@rabbit-api-001 test]
total
-rw-r--r-- 1 root root 12 Apr 30 13:58
-rw-r--r-- 1 root root 12 Apr 30 13:58
drwxr-xr-x 10 root root 328 Apr 29 10:28
-rw-r--r-- 1 root root 529365 Apr 28 21:25
-rw-r--r-- 1 root root 241 Apr 28 07:57
-rw-r--r-- 1 root root 42 Apr 28 20:34
[root@rabbit-api-001 test]
536
-rw-r--r-- 1 root root 12 Apr 30 a.txt
-rw-r--r-- 1 root root 12 Apr 30 b.txt
drwxr-xr-x 10 root root 328 Apr 29 djmockserver
-rw-r--r-- 1 root root 529365 Apr 28 djmockserver.zip
-rw-r--r-- 1 root root 241 Apr 28 select.sh
-rw-r--r-- 1 root root 42 Apr 28 test.txt
替换指定列
[root@rabbit-api-001 test]
total 536 mysql
-rw-r--r-- 1 root mysql 12 Apr 30 13:58 a.txt
-rw-r--r-- 1 root mysql 12 Apr 30 13:58 b.txt
drwxr-xr-x 10 root mysql 328 Apr 29 10:28 djmockserver
-rw-r--r-- 1 root mysql 529365 Apr 28 21:25 djmockserver.zip
-rw-r--r-- 1 root mysql 241 Apr 28 07:57 select.sh
-rw-r--r-- 1 root mysql 42 Apr 28 20:34 test.txt