sed处理文件?

wd_my

有A文件两列数据，如何将红色标记的换成制表符（\t）变成想要的B文件呢？
scaffold5729_0.0_139982_147655_5        scaffold5729_0.0_139982_147655_5        
scaffold5755_0.0_39667_53398_5  scaffold5755_0.0_39667_53398_5
scaffold5755_0.0_39657_53398_5  scaffold5755_0.0_39657_53398_5  
super11_227743_234237_5 super11_227743_234237_5
super11_227752_234257_5 super11_227752_234257_5
super11_227726_234237_5 super11_227726_234237_5

B文件如下：
scaffold5729_0.0_139982_147655_5        scaffold5729 139982 147655         
scaffold5755_0.0_39667_53398_5  scaffold5755 39667 53398  
scaffold5755_0.0_39657_53398_5  scaffold5755 39657 53398
super11_227743_234237_5 super11 227743 234237
super11_227752_234257_5 super11 227752 234257  
super11_227726_234237_5 super11 227726 234237

christmas1102

1. sed -ri 's#(_0\.0_)|(_)|(_5)#\t#g' file

复制代码

christmas1102

1. 
   

复制代码

wd_my

回复 2# christmas1102

你好，这样的结果是两列的红色的都被替换了，我只是想第二列的红色部分被\t替换掉

1cpuer

回复 1# wd_my

# [ /home/soio/1bs/awks ] {2018-05-01 14:29:07}
: 1525156147:0;➜  sed -r 's#[ ]#@#g; s#(@@*.*)(_0\.0_)#\1[\t]#g; s#(@@*.*)(_)(.*)(_5)#\1[ \t]\3[ \t]#g' x_5
scaffold5729_0.0_139982_147655_5@@@@@@@@scaffold5729[    ]139982[     ]147655[     ]@@@@@@@@
scaffold5755_0.0_39667_53398_5@@scaffold5755[    ]39667[     ]53398[     ]
scaffold5755_0.0_39657_53398_5@@scaffold5755[    ]39657[     ]53398[     ]@@
super11_227743_234237_5@super11_227743[     ]234237[     ]
super11_227752_234257_5@super11_227752[     ]234257[     ]
super11_227726_234237_5@super11_227726[     ]234237[     ]

将@改 \x20 | [ ] ; {[ \t] 改 \t}

其实用 awk 更好理解
$2 gsub()

wd_my

回复 5# 1cpuer

不好意思大神，没能理解你的思路

1cpuer

回复 6# wd_my

# [ /home/soio/1bs/awks ] {2018-05-01 15:07:04}
: 1525158424:0;➜  sed -r 's#([ ][ ]*.*)(_0\.0_)#\1\t#g; s#([ ][ ]*.*)(_)(.*)(_5)#\1\t\3\t#g' x_5
scaffold5729_0.0_139982_147655_5        scaffold5729    139982    147655            
scaffold5755_0.0_39667_53398_5  scaffold5755    39667    53398   
scaffold5755_0.0_39657_53398_5  scaffold5755    39657    53398      
super11_227743_234237_5 super11_227743    234237   
super11_227752_234257_5 super11_227752    234257   
super11_227726_234237_5 super11_227726    234237



   
# [ /home/soio/1bs/awks ] {2018-05-01 15:13:28}
: 1525158808:0;➜  awk '{gsub(/(_0\.0_)|(_)|(_5)/, " ", $2)}1' x_5
scaffold5729_0.0_139982_147655_5 scaffold5729 139982 147655
scaffold5755_0.0_39667_53398_5 scaffold5755 39667 3398
scaffold5755_0.0_39657_53398_5 scaffold5755 39657 3398
super11_227743_234237_5 super11 227743 234237
super11_227752_234257_5 super11 227752 234257
super11_227726_234237_5 super11 227726 234237

wd_my

回复 7# 1cpuer

输进去之后没有变化，还是原先的两列

wh7211

回复 1# wd_my

1. awk '{$2=gensub("_0.0_|_|_5$","\t","g",$2)}1' file
   
2. sed -r 's/( +[^_]+)(_0\.0_|_)([^_]+)_([^_]+)_5$/\1\t\3\t\4\t/g' file

复制代码

1cpuer

回复 8# wd_my

把打印为原题的 list
是测试的 sed -r 的那个吗?
# [ /home/soio/1bs/awks ] {2018-05-04 01:09:30}
: 1525367370:0;➜  sed -r 's/([ ][ ]*.*)(_0\.0_)/\1\t/g; s/([ ][ ]*.*)(_)(.*)(_5)/\1\t\3\t/g' x_5
scaffold5729_0.0_139982_147655_5        scaffold5729    139982    147655            
scaffold5755_0.0_39667_53398_5  scaffold5755    39667    53398   
scaffold5755_0.0_39657_53398_5  scaffold5755    39657    53398      
super11_227743_234237_5 super11_227743    234237   
super11_227752_234257_5 super11_227752    234257   
super11_227726_234237_5 super11_227726    234237   



# [ /home/soio/1bs/awks ] {2018-05-04 01:09:49}
: 1525367389:0;➜  sed 's/([ ][ ]*.*)(_0\.0_)/\1\t/g; s/([ ][ ]*.*)(_)(.*)(_5)/\1\t\3\t/g' x_5
sed: -e 表达式 #1, 字符 29: “s”命令的RHS非法引用\1↵


# [ /home/soio/1bs/awks ] {2018-05-04 01:09:59}
: 1525367399:0;➜  sed -r 's/(  *.*)(_0\.0_)/\1\t/g; s/([ ][ ]*.*)(_)(.*)(_5)/\1\t\3\t/g' x_5
scaffold5729_0.0_139982_147655_5        scaffold5729    139982    147655            
scaffold5755_0.0_39667_53398_5  scaffold5755    39667    53398   
scaffold5755_0.0_39657_53398_5  scaffold5755    39657    53398      
super11_227743_234237_5 super11_227743    234237   
super11_227752_234257_5 super11_227752    234257   
super11_227726_234237_5 super11_227726    234237   



# [ /home/soio/1bs/awks ] {2018-05-04 01:10:53}
: 1525367453:0;➜  sed -r 's/(\ \ *.*)(_0\.0_)/\1\t/g; s/([ ][ ]*.*)(_)(.*)(_5)/\1\t\3\t/g' x_5
scaffold5729_0.0_139982_147655_5        scaffold5729    139982    147655            
scaffold5755_0.0_39667_53398_5  scaffold5755    39667    53398   
scaffold5755_0.0_39657_53398_5  scaffold5755    39657    53398      
super11_227743_234237_5 super11_227743    234237   
super11_227752_234257_5 super11_227752    234257   
super11_227726_234237_5 super11_227726    234237   



# [ /home/soio/1bs/awks ] {2018-05-04 01:11:00}
: 1525367460:0;➜  sed -r 's/(\x20\x20*.*)(_0\.0_)/\1\t/g; s/([ ][ ]*.*)(_)(.*)(_5)/\1\t\3\t/g' x_5
scaffold5729_0.0_139982_147655_5        scaffold5729    139982    147655            
scaffold5755_0.0_39667_53398_5  scaffold5755    39667    53398   
scaffold5755_0.0_39657_53398_5  scaffold5755    39657    53398      
super11_227743_234237_5 super11_227743    234237   
super11_227752_234257_5 super11_227752    234257   
super11_227726_234237_5 super11_227726    234237