2012年11月6日 星期二

awk sed 處理欄位 列


刪除全文空白行  用 vi
:g/^[<Space><Tab>]*$/d  
:g/^[ ^I]*$/d


去除 在awk 螢幕輸出file 之後產生多餘的^M

:1,$s/<CTRL>+<v> <CTRL>+<m>//g

將多欄分開


325.sh script
awk '{printf $1 "\t" "\n"}' 325  > A325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $2 "\t" "\n"}' 325 > B325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $3 "\t" "\n"}' 325 > C325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $4 "\t" "\n"}' 325 > D325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $5 "\t" "\n"}' 325 > E325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $6 "\t" "\n"}' 325 > F325
awk ' NR%5==1;NR%5==4 {printf $1 "\t" "\n"}   NR%5!=1 {printf $7 "\t" "\n"}' 325 > G325

325  file
--

OBS32510352432
   2.4146e+01   2.4191e+01   2.4269e+01   1.5132e-01   3.0528e-02   5.7997e+03   2.9464e+01
   5.0289e+00   4.9964e+00   5.0909e+00   1.1074e-02   3.4971e-03   6.6818e+02   3.0671e+00
140000
   1.3440e-02   1.3353e-02   1.3606e-02   2.9596e-05   9.3464e-06   1.7858e+00   8.1972e-03
OBS32510602432
   2.4761e+01   2.4774e+01   2.4784e+01   1.5144e-01   3.0568e-02   5.9472e+03   2.8755e+01
   5.1367e+00   5.1333e+00   5.1684e+00   1.1118e-02   3.5050e-03   6.8592e+02   3.0256e+00
140000
   1.3728e-02   1.3719e-02   1.3813e-02   2.9715e-05   9.3675e-06   1.8332e+00   8.0863e-03
.....
---

B325
--
2.5392e+01
5.2551e+00
140000

1.4045e-02
OBS32511152432
2.5989e+01
5.4133e+00
140000

1.4468e-02
...
---



沒有留言:

張貼留言