- 论坛徽章:
- 0
|
本帖最后由 maaiika 于 2016-01-22 16:08 编辑
请问用 awk 或者sed怎么处理空的行
例如
nbu_master_w#[/tmp]bpdbjobs -report | head -50 | awk 'NR>2{print p}{p=$0}'
248657 Catalog Backup Done 0 catalog_backup vault_catalogbak nbu_master_w nbu_master_w 9502966 No
248656 Catalog Backup Done 0 catalog_backup vault_catalogbak nbu_master_w nbu_master_w 11075750 No
248655 Catalog Backup Done 0 catalog_backup vault_catalogbak nbu_master_w 14942458
248654 Catalog Backup Done 0 catalog_backup - nbu_master_w nbu_master_w No
248653 Duplication Done 0 nbu_master_w nbu_master_w 10092680
248652 Duplication Done 0 nbu_master_w nbu_master_w 14942292
248651 Duplication Done 0 nbu_master_w nbu_master_w 11272222
248650 Duplication Done 0 nbu_master_w nbu_master_w 14155862
248649 Duplication Done 0 nbu_master_w nbu_master_w 14942290
248648 Duplication Done 0 nbu_master_w nbu_master_w 14942288
248647 Duplication Done 0 nbu_master_w nbu_master_w 11272220
248646 Duplication Done 0 nbu_master_w nbu_master_w 14483506
248645 Duplication Done 0 nbu_master_w nbu_master_w 14155860
248644 Vault Done 0 vault_w vault_run nbu_master_w nbu_master_w 3735782 No
248643 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 15859934 No
248642 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9830650 No
248641 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 10092796 No
248640 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13893788 No
248639 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 11862096 No
248638 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9437266 No
248637 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 11862084 No
248636 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 10092696 No
248635 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13238458 No
248634 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 11403334 No
248633 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 8782030 No
248632 Image Delete Done 0 12451924
248631 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9830428 No
248630 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 14286974 No
248629 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 10092674 No
248628 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13893706 No
248627 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9437406 No
248626 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 14286954 No
248625 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9502898 No
248624 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 14286928 No
248623 Catalog Backup Done 0 catalog_backup catalog_full nbu_master_w nbu_master_w 9765060 No
248622 Catalog Backup Done 0 catalog_backup catalog_full nbu_master_w nbu_master_w 12714186 No
248621 Catalog Backup Done 0 catalog_backup catalog_full nbu_master_w 15400982
248620 Catalog Backup Done 0 catalog_backup - nbu_master_w nbu_master_w No
248619 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13893878 No
248618 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 11010278 No
248617 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13893848 No
248616 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9437426 No
248615 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 13893760 No
248614 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 14942400 No
248613 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 15401112 No
248612 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 9764870 No
248611 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 15401078 No
248610 Backup Done 0 gkwwdb1_oracle_full Application-gkwwdb1 gkwwdb1 nbu_master_w 11010056 No
nbu_master_w#[/tmp]
nbu_master_w#[/tmp]bpdbjobs -report | head -50 | awk 'NR>2{print p}{p=$0}' | sed "s/^ /X /g" | sed "s/ / X/g"
248657 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X nbu_master_w X X9502966 X X XNo
248656 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X nbu_master_w X 11075750 X X XNo
248655 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X X X X X X X X X14942458 X X X X
248654 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X X X X X X X X X- X X X nbu_master_w X nbu_master_w X X X X X X X X No
248653 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 10092680 X X X X
248652 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942292 X X X X
248651 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 11272222 X X X X
248650 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14155862 X X X X
248649 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942290 X X X X
248648 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942288 X X X X
248647 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 11272220 X X X X
248646 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14483506 X X X X
248645 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14155860 X X X X
248644 X X X X XVault XDone X X X0 X X X X X X Xvault_w X X X X X X X X Xvault_run X X X nbu_master_w X nbu_master_w X X3735782 X X XNo
248643 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 15859934 X X XNo
248642 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9830650 X X XNo
248641 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092796 X X XNo
248640 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 13893788 X X XNo
248639 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11862096 X X XNo
248638 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9437266 X X XNo
248637 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11862084 X X XNo
248636 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092696 X X XNo
248635 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 13238458 X X XNo
248634 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11403334 X X XNo
248633 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X8782030 X X XNo
248632 X Image Delete XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X 12451924 X X X X
248631 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9830428 X X XNo
248630 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 14286974 X X XNo
248629 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092674 X X XNo
248628 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 13893706 X X XNo
nbu_master_w#[/tmp]bpdbjobs -report | head -50 | awk 'NR>2{print p}{p=$0}' | awk '{gsub(/^ {2}/,"X ");gsub(/ {2}/," X")}1'
248657 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X nbu_master_w X X9502966 X X XNo
248656 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X nbu_master_w X 11075750 X X XNo
248655 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X vault_catalogbak X X X nbu_master_w X X X X X X X X X14942458 X X X X
248654 Catalog Backup XDone X X X0 X X X catalog_backup X X X X X X X X X X X X X- X X X nbu_master_w X nbu_master_w X X X X X X X X No
248653 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 10092680 X X X X
248652 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942292 X X X X
248651 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 11272222 X X X X
248650 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14155862 X X X X
248649 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942290 X X X X
248648 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14942288 X X X X
248647 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 11272220 X X X X
248646 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14483506 X X X X
248645 X XDuplication XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X nbu_master_w X nbu_master_w X 14155860 X X X X
248644 X X X X XVault XDone X X X0 X X X X X X Xvault_w X X X X X X X X Xvault_run X X X nbu_master_w X nbu_master_w X X3735782 X X XNo
248643 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 15859934 X X XNo
248642 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9830650 X X XNo
248641 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092796 X X XNo
248640 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 13893788 X X XNo
248639 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11862096 X X XNo
248638 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9437266 X X XNo
248637 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11862084 X X XNo
248636 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092696 X X XNo
248635 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 13238458 X X XNo
248634 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 11403334 X X XNo
248633 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X8782030 X X XNo
248632 X Image Delete XDone X X X0 X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X X 12451924 X X X X
248631 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X X9830428 X X XNo
248630 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 14286974 X X XNo
248629 X X X X Backup XDone X X X0 Xgkwwdb1_oracle_full X X X XApplication-gkwwdb1 X X X X X Xgkwwdb1 X nbu_master_w X 10092674 X X XNo
请问用 awk 或者sed怎么处理空的行
例如
a b c d e
1 2 3 4
2 2 3 5
3 4 4 6
如果我用awk去匹配空格是没法匹配到的
有没有方法替换其中行/列的空位置为值
如 下面的效果
a b c d e
1 X 2 3 4
2 2 3 X 5
X 3 4 4 6
|
|