如何将文件中符合条件的两行合并为一行

刘彩霞

如下图，是测试输出结果，

期望将图片中红色两行变成
下面格式的一行


附件是输出的原文件
result.rar (489 Bytes, 下载次数: 16)

2014-08-22 14:29 上传

点击文件名下载附件

MeRcy_PM

没瞅出啥规律。。。红色就圈了一行吧。。。完全没变，换个底色么。。。

刘彩霞

回复 2# MeRcy_PM
不是，原来是2行，想换成一行，就把两行的第一列合，中间以-连接


   

bulletmarquis

cat abc
a
1 2 3
a 2 5
a
2 34 5

cat abc|awk 'NF==1{printf "%s-", $1}NF!=1{printf "%s\n",$0}'
a-1 2 3
a 2 5
a-2 34 5

cat abc|awk 'NF==1{printf "%s-", $1;next}1'
a-1 2 3
a 2 5
a-2 34 5

MeRcy_PM

回复 3# 刘彩霞
看漏了
@linux:~/mytest/shell> dos2unix result.csv dos2unix: converting file result.csv to UNIX format ...
@linux:~/mytest/shell> sed '/randrw,/{N;s/,*\n/-/}' result.csv  
Test-Mode,Queue-Depth,Blocksize,IOPS,Bandwidth,Latency,CPUusr%,CPUsys%
randread,1,4k,80,0.31MB,12.41,0.12%,0.35%
randread,2,4k,94,0.37MB,21.12,0.20%,0.48%
randread,4,4k,118,0.46MB,33.84,0.17%,0.53%
randread,8,4k,142,0.56MB,56.09,0.23%,0.62%
randread,16,4k,172,0.67MB,92.7,0.39%,0.85%
randread,32,4k,208,0.81MB,153.44,0.30%,0.90%
,,,,,,,
randrw-100,1,4k,81,0.32MB,12.29,0.14%,0.34%
,,,,,,,
,,,,,,,
randrw-100,2,4k,94,0.37MB,21.11,0.17%,0.49%
,,,,,,,
randrw-100,4,4k,118,0.46MB,33.68,0.27%,0.58%
,,,,,,,
randrw-100,8,4k,143,0.56MB,55.8,0.24%,0.75%
,,,,,,,
randrw-100,16,4k,172,0.68MB,92.5,0.26%,0.99%
,,,,,,,
randrw-100,32,4k,205,0.80MB,155.47,0.39%,1.06%
,,,,,,,
randrw-100,1,4k,81,0.32MB,12.26,0.13%,0.35%
,,,,,,,
randrw-100,2,4k,94,0.37MB,21.13,0.14%,0.43%
,,,,,,,
randrw-100,4,4k,117,0.46MB,33.89,0.24%,0.58%
,,,,,,,
randrw-100,8,4k,142,0.56MB,56.05,0.18%,0.65%
,,,,,,,
randrw-100,16,4k,173,0.68MB,92.19,0.30%,0.70%
,,,,,,,
randrw-100,32,4k,207,0.81MB,153.98,0.36%,1.14%
,,,,,,,
randrw-100,1,4k,81,0.32MB,12.3,0.10%,0.40%
,,,,,,,
randrw-100,2,4k,94,0.37MB,21.16,0.13%,0.43%
,,,,,,,
randrw-100,4,4k,118,0.46MB,33.73,0.20%,0.49%
,,,,,,,
randrw-100,8,4k,141,0.55MB,56.38,0.32%,0.69%
,,,,,,,
randrw-100,16,4k,172,0.68MB,92.45,0.26%,0.74%
,,,,,,,
randrw-100,32,4k,206,0.81MB,154.92,0.29%,0.89%
,,,,,,,
randrw-100,1,4k,81,0.32MB,12.26,0.12%,0.33%
,,,,,,,
randrw-100,2,4k,94,0.37MB,21.18,0.14%,0.42%
@linux:~/mytest/shell>
   不过要dos2unix。。。不然结果出不来。。

刘彩霞

回复 5# MeRcy_PM

就是这么个意思，大赞。   

li0924

1. awk 'NF==1{t=$1;getline;$1=t "-" $1}1'

复制代码

dn833

1. sed  '/^randrw,,*/{N;s/,,*.\n/-/}'

复制代码

LZ给的源文件有^M