求一段命令，处理科学计数以及插入空格。。。

arudebar

用sox得到了一个文本文件。

; Sample Rate 48000
; Channels 1
               0     0.0076293945
  2.0833333e-005     0.0090942383
  4.1666667e-005      0.010131836
       6.25e-005      0.010925293
  8.3333333e-005     0.0057373047
   0.00010416667     0.0085754395
        0.000125     0.0086669922
   0.00014583333      0.008605957
   0.00016666667      0.010223389
       0.0001875       0.01071167



我现在要：

1，去掉前2行（这个已经做到了），

2，去掉每行头尾的空格

3，把科学计数都转成浮点数

4，把两个数字间的空格替换成一个逗号。

试了一下午，还是写不好。求大神指点。

ly5066113

回复 1# arudebar


try:

1. awk 'NR>2{printf "%.10f,%.10f\n",$1,$2}' file

复制代码

jason680

回复 1# arudebar

How about this one ...

$ awk '/^;/{next}{printf("%f,%f\n",$1,$2)}' FILE
0.000000,0.007629
0.000021,0.009094
0.000042,0.010132
0.000063,0.010925
0.000083,0.005737
0.000104,0.008575
0.000125,0.008667
0.000146,0.008606
0.000167,0.010223
0.000188,0.010712

   

arudebar

楼上都是大神啊！！！

bulletmarquis

1. awk '!/^;/{printf "%f,%f\n",$1,$2}'  file

复制代码

yestreenstars

1. awk 'NR>2{printf "%f,%f\n",$1,$2}'

复制代码

o789789

cat test4 |awk -F"[ ]+" 'NR>2{printf("%f,%f\n",$2,$3)}'