如何处理这个问题

wjw870907

cat file
name,811,aaa|bbb|ccc|ddd|eee|fff
support,812,
t_member,820,ccc|eee|fff
icac,821,
datax,822,aaa|ccc
exchange,823,bbb
jv,900,


变成
name,811,aaa
name,811,bbb
name,811,cc
name,811,ddd
name,811,eee

support,812,
t_member,820,ccc
t_member,820,eee
t_member,820,fff
icac,821,
datax,822,aaa
datax,822,ccc
exchange,823,bbb
jv,900,

Looiml

1. sed -r ':a;s/^(.*,)([^|]+)\|(.*)$/\1\2\n\1\3/m;ta' a.txt

复制代码

name,811,aaa
name,811,bbb
name,811,ccc
name,811,ddd
name,811,eee
name,811,fff
support,812,
t_member,820,ccc
t_member,820,eee
t_member,820,fff
icac,821,
datax,822,aaa
datax,822,ccc
exchange,823,bbb
jv,900,

wjw870907

回复 2# Looiml

谢谢

wh7211

回复 1# wjw870907

1. cat 1
   
2. name,811,aaa|bbb|ccc|ddd|eee|fff
   
3. support,812,
   
4. t_member,820,ccc|eee|fff
   
5. icac,821,
   
6. datax,822,aaa|ccc
   
7. exchange,823,bbb
   
8. jv,900,
   
9. 
   
10. awk -F"," '$NF~/\|/{match($0,"^(.*,)[^,]+$",a);c=split($NF,b,"|");$0="";for(i=1;i<=c;i++){$0=$0?$0"\n"a[1]b[i]:a[1]b[i]}}1' 1
    
11. name,811,aaa
    
12. name,811,bbb
    
13. name,811,ccc
    
14. name,811,ddd
    
15. name,811,eee
    
16. name,811,fff
    
17. support,812,
    
18. t_member,820,ccc
    
19. t_member,820,eee
    
20. t_member,820,fff
    
21. icac,821,
    
22. datax,822,aaa
    
23. datax,822,ccc
    
24. exchange,823,bbb
    
25. jv,900,

复制代码