论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2015-06-11 17:19 |只看该作者 |倒序浏览

想补齐所有空的字段，并使用前一行的字段，方便后续的分析，感觉很困难
|title1 |title2 |title3 |title4 |title5 |title6
|PC    |1.0 |0    |1    |2    |3
|       |       |       |1.1 |2.1 |3.1
|       |       |    |1.2    |2.2 |3.2
|       |       |1    |2    |3    |4
|       |       |       |2.1 |3.1 |4.1
|       |2.0 |0    |1    |2    |3
|       |       |    |1.1 |2.1 |3.1
|       |       |    |1.2 |2.2 |3.2
|       |       |1    |2    |3    |4
|       |       |    |2.1 |3.1 |4.1
|mobile |1.0 |0    |1    |2    |3
|       |       |       |1.1 |2.1 |3.1
|       |       |    |1.2    |2.2 |3.2
|       |       |1    |2    |3    |4
|       |       |       |2.1 |3.1 |4.1
|       |2.0 |0    |1    |2    |3
|       |       |    |1.1 |2.1 |3.1
|       |       |    |1.2 |2.2 |3.2
|       |       |1    |2    |3    |4
|       |       |    |2.1 |3.1 |4.1

输出类似如下：
|title1 |title2 |title3 |title4 |title5 |title6
|PC    |1.0 |0    |1    |2    |3
|PC    |1.0 |0       |1.1 |2.1 |3.1
|PC    |1.0 |0    |1.2    |2.2 |3.2
|PC    |1.0 |1    |2    |3    |4
|PC    |1.0 |1       |2.1 |3.1 |4.1
|PC    |2.0 |0    |1    |2    |3
|PC    |2.0 |0    |1.1 |2.1 |3.1
|PC    |2.0 |0    |1.2 |2.2 |3.2
|PC    |2.0 |1    |2    |3    |4
|PC    |2.0 |1    |2.1 |3.1 |4.1
|mobile |1.0 |0    |1    |2    |3
|mobile |1.0 |0       |1.1 |2.1 |3.1
|mobile |1.0 |0    |1.2    |2.2 |3.2
|mobile |1.0 |1    |2    |3    |4
|mobile |1.0 |1       |2.1 |3.1 |4.1
|mobile |2.0 |0    |1    |2    |3
|mobile |2.0 |0    |1.1 |2.1 |3.1
|mobile |2.0 |0    |1.2 |2.2 |3.2
|mobile |2.0 |1    |2    |3    |4
|mobile |2.0 |1    |2.1 |3.1 |4.1

mobile

文库|博客

lifayi2008

家境小康

论坛徽章:: 9

2楼 [报告]

发表于 2015-06-11 17:31 |只看该作者

awk 'BEGIN{FS=OFS="|"}{for(i=1;i<=NF;i++){if($i~/^ +$/){$i=a[i]}else{a[i]=$i}}}1' test.txt

复制代码

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

Herowinter

富可敌国

论坛徽章:: 769

3楼 [报告]

发表于 2015-06-11 17:38 |只看该作者

回复 1# joan8363

awk 'BEGIN{FS=OFS="|"} NR>1{for(i=2;i<=NF;i++)if($i~/^[[:space:]]*$/)$i=a[i];else a[i]=$i}1' i
|title1 |title2 |title3 |title4 |title5 |title6
|PC |1.0 |0 |1 |2 |3
|PC |1.0 |0 |1.1 |2.1 |3.1
|PC |1.0 |0 |1.2 |2.2 |3.2
|PC |1.0 |1 |2 |3 |4
|PC |1.0 |1 |2.1 |3.1 |4.1
|PC |2.0 |0 |1 |2 |3
|PC |2.0 |0 |1.1 |2.1 |3.1
|PC |2.0 |0 |1.2 |2.2 |3.2
|PC |2.0 |1 |2 |3 |4
|PC |2.0 |1 |2.1 |3.1 |4.1
|mobile |1.0 |0 |1 |2 |3
|mobile |1.0 |0 |1.1 |2.1 |3.1
|mobile |1.0 |0 |1.2 |2.2 |3.2
|mobile |1.0 |1 |2 |3 |4
|mobile |1.0 |1 |2.1 |3.1 |4.1
|mobile |2.0 |0 |1 |2 |3
|mobile |2.0 |0 |1.1 |2.1 |3.1
|mobile |2.0 |0 |1.2 |2.2 |3.2
|mobile |2.0 |1 |2 |3 |4
|mobile |2.0 |1 |2.1 |3.1 |4.1