求助

drakness

求助个问题，我有一段数据，格式是这样的：

1. 45SD123SD123TP_X_ACTRow-X (SX)ad45SD123SD123FK_T_ASTRow-X (SX)wd45SD123SD123TI_TY_ACTRow-X (SX)wd
   
2. 45SD123SD123TOT_ACTOSRow-X (SX)ad45SD123SD123TL_QT_ATCTRow-X (SX)wd45SD123SD123TP_T_ACTRow-X (SX)wd
   
3. 45SD123SD123TP_T_ACTRow-X (SX)ad45SD123SD123TP_T_ACTRow-X (SX)wd45SD123SD123

复制代码

怎么能得到

1. TP_X_ACT  FK_T_AST  TI_TY_ACT
   
2. TOT_ACTOS  TL_QT_ATCT  TP_T_ACT
   
3. TP_T_ACT  TP_T_ACT  TP_T_ACT

复制代码

drakness

自己写的太麻烦，期待简便的方法

MMMIX

drakness 发表于 2015-07-28 18:01
自己写的太麻烦，

贴上来看看

drakness

回复 3# MMMIX


    太笨了，使用perl 's///' 一点点删除的

jason680

回复 1# drakness

What You Want Is Want You Code(WYWIWYC)

$ cat FILE
45SD123SD123TP_X_ACTRow-X (SX)ad45SD123SD123FK_T_ASTRow-X (SX)wd45SD123SD123TI_TY_ACTRow-X (SX)wd
45SD123SD123TOT_ACTOSRow-X (SX)ad45SD123SD123TL_QT_ATCTRow-X (SX)wd45SD123SD123TP_T_ACTRow-X (SX)wd
45SD123SD123TP_T_ACTRow-X (SX)ad45SD123SD123TP_T_ACTRow-X (SX)wd45SD123SD123


$ perl -lane '{print join(" ",m/\d(\D+?)Row-X/g)}' FILE
TP_X_ACT FK_T_AST TI_TY_ACT
TOT_ACTOS TL_QT_ATCT TP_T_ACT
TP_T_ACT TP_T_ACT

   

zxy877298415

1. awk -F 'Row' '{for(i=1;i<NF;i++) {split($i,a,"");for(j=length(a);j>0;j--) {if(a[j]~/[0-9]/) {break} else {t=t a[j]}}split(t,b,"");for(k=length(b);k>0;k--) {printf b[k]};printf " ";t=""}print ""}' file
   
2. TP_X_ACT FK_T_AST TI_TY_ACT
   
3. TOT_ACTOS TL_QT_ATCT TP_T_ACT
   
4. TP_T_ACT TP_T_ACT

复制代码

回复 1# drakness


   

798229502

方法比较笨，但是也可以实现你这个例子sed 's/Row/123/g' a.txt | awk -F '123' '{print $3"\t"$6"\t"$9}'

Herowinter

回复 1# drakness

针对你的文本，理论上这样就可以得到你想要的结果。
最后一行第3列是按前两列补上的？

grep -Po "[_A-Z]*(?=Row-X)" urfile|xargs -n3
   

songyc_2015

回复 1# drakness

1. $awk '{s=$0;while(match(s,/[0-9]([^0-9]+)Row-X/,a)>0){printf a[1]" ";s=substr(s,a[1,"start"]+a[1,"length"])}print ""}' file
   
2. TP_X_ACT FK_T_AST TI_TY_ACT
   
3. TOT_ACTOS TL_QT_ATCT TP_T_ACT
   
4. TP_T_ACT TP_T_ACT
   

复制代码

2008431

awk -F'123SD123' '{print $2,$3,$4}' a.txt | awk -F 'Row-X' '{print $1,$2,$3}' |awk '{print $1,$3,$5}'
TP_X_ACT FK_T_AST TI_TY_ACT
TOT_ACTOS TL_QT_ATCT TP_T_ACT
TP_T_ACT TP_T_ACT