求指点

noshell

文本3列如下：

asassadcsa 2.0 10001,2000,1003,5007
asassadcsa 2.0  2000,100001,2000
asakdllkjljop 3.1 50001,600007,80002
asakdllkjljop 3.1 20001,60007
asjldjajdsad 4.1 60001

处理成

asassadcsa 2.0 10001
asassadcsa 2.0 2000
asassadcsa 2.0 1003
asassadcsa 2.0 5007
asassadcsa 2.0  2000
asassadcsa 2.0 100001
asassadcsa 2.0 2000
asakdllkjljop 3.1 50001
asakdllkjljop 3.1 600007
asakdllkjljop 3.1 80002
asakdllkjljop 3.1 20001
asakdllkjljop 3.1 60007
asjldjajdsad 4.1 60001

yestreenstars

又是此类月经题~{:3_193:}

ly5066113

回复 1# noshell


try:

1. sed -r 's/(.* )([^,]+),/\1\2\n\1/;P;D' file

复制代码

dn833

1. awk -F '[ ,]+' '{for(i=3;i<=NF;i++)print $1,$2,$i}'

复制代码

这个意思？

noshell

就是把第三列的查分掉，变成每行3列回复 4# dn833


   

noshell

求大神指点回复 3# ly5066113


   

noshell

貌似不可以回复 4# dn833


   

dn833

1. [root@FILE_SHARE tmp]# cat b
   
2. asassadcsa 2.0 10001,2000,1003,5007
   
3. asassadcsa 2.0  2000,100001,2000
   
4. asakdllkjljop 3.1 50001,600007,80002
   
5. asakdllkjljop 3.1 20001,60007
   
6. asjldjajdsad 4.1 60001
   
7. [root@FILE_SHARE tmp]# awk -F '[ ,]+' '{for(i=3;i<=NF;i++)print $1,$2,$i}' b
   
8. asassadcsa 2.0 10001
   
9. asassadcsa 2.0 2000
   
10. asassadcsa 2.0 1003
    
11. asassadcsa 2.0 5007
    
12. asassadcsa 2.0 2000
    
13. asassadcsa 2.0 100001
    
14. asassadcsa 2.0 2000
    
15. asakdllkjljop 3.1 50001
    
16. asakdllkjljop 3.1 600007
    
17. asakdllkjljop 3.1 80002
    
18. asakdllkjljop 3.1 20001
    
19. asakdllkjljop 3.1 60007
    
20. asjldjajdsad 4.1 60001

复制代码

noshell

多谢大神 可以了 我看错了回复 8# dn833


   

dn833

cp工程师不好做