求助文本处理

wjw870907

/rawdata/db,3
/rawdata/db/ecc/ecc_ekpo,6
/user/b2b_wang_jianhui,5
/user/yonghuietl,4
/user/yonghuietl/.Trash,5
/warehouse/dw,4
/warehouse/dw/sale/sale_sap_order_fct,6

有子目录就在前面加个逗号，像这样
/rawdata/db,3
,/rawdata/db/ecc/ecc_ekpo,6
/user/b2b_wang_jianhui,5
/user/yonghuietl,4
,/user/yonghuietl/.Trash,5
/warehouse/dw,4
,/warehouse/dw/sale/sale_sap_order_fct,6

reyleon

1. awk -F/ 'NF>3{$0=","$0}1' file

复制代码

Herowinter

回复 1# wjw870907

1. awk -vFS=, '{b=0;for(i in a)if($1~i){b=1;$1=","$1;break};if(b==0)a[$1];print}' i
   
2. /rawdata/db,3
   
3. ,/rawdata/db/ecc/ecc_ekpo 6
   
4. /user/b2b_wang_jianhui,5
   
5. /user/yonghuietl,4
   
6. ,/user/yonghuietl/.Trash 5
   
7. /warehouse/dw,4
   
8. ,/warehouse/dw/sale/sale_sap_order_fct 6

复制代码

wh7211

回复 1# wjw870907

1. awk -F"," '{if(a&&$1~""a"/"){$0=","$0}else{a=$1}}1' file

复制代码

wjw870907

谢谢大神们

wjw870907

回复 4# wh7211

还有个需求，如果以逗号分隔，如果NF==4的，在第二个逗号后面在加一个逗号比如
,/warehouse/dw/sale/sale_sap_order_fct,6G,7T变成
,/warehouse/dw/sale/sale_sap_order_fct,,6G,7T

wh7211

回复 6# wjw870907

1. awk 'BEGIN{FS=OFS=","}NF==4{print $1,$2,"",$3,$4}' file
   
2. awk -F"," 'NF==4{$0=gensub(",",",,","2",$0)}1' file

复制代码