awk处理

liaoboda

'ENSP00000240361':  
  TEX14 - testis expressed 14; Required for spermatogenesis and male fertility. May be required for normal structure of the intercellular bridge that connects spermatocytes and spermatogonia. Has no protein kinase activity (in vitro) (By similarity)
ENSP00000240619':  
  TAS2R10 - taste receptor, type 2, member 10; Gustducin-coupled strychnine receptor implicated in the perception of bitter compounds in the oral cavity and the gastrointestinal tract. Signals through PLCB2 and the calcium- regulated cation channel TRPM5  
'ENSP00000242576':  
  UNG - uracil-DNA glycosylase; Excises uracil residues from the DNA which can arise as a result of misincorporation of dUMP residues by DNA polymerase or due to deamination of cytosine (By similarity)  
'ENSP00000243457':  
  KCNJ2 - potassium inwardly-rectifying channel, subfamily J, member 2; Probably participates in establishing action potential waveform and excitability of neuronal and muscle tissues. Inward rectifier potassium channels are characterized by a greater tendency to allow potassium to flow into the cell rather than out of it. Their voltage dependence is regulated by the concentration of extracellular potassium; as external potassium is raised, the voltage range of the channel opening shifts to more positive voltages. The inward rectification is mainly due to the blockage of outward current by inter [...]   

我要吧'ENSP00000240361':   TEX14   - testis expressed 14; Required for spermatogenesis and male fertility. May be required for normal structure of the intercellular bridge that connects spermatocytes and spermatogonia. Has no protein kinase activity (in vitro) (By similarity)
分成3列 然后要用ENSP00000240361 去匹配另外一个文件里边的一个号.

多谢了

TasteOracle

他们都表示没有看懂你的意思？咋办？

liaoboda

比如
'123456':
AVD - dfdsa dsfsdf fklsdfjsa;fsafsfsf
'234456':
CDR- dfasfsadfsad dsaffsdfsadfsf

我要的结果
123456   AVD    dfdsa dsfsdf fklsdfjsa;fsafsfsf
234456   CDR    dfasfsadfsad dsaffsdfsadfsf

liaoboda

不好意思 没写清楚

ywlscpl

回复 3# liaoboda

没看清，原来还要删'号

1. awk -F "'" '$0~"^"FS{printf $2;next}{sub(/-/,"")}1' file

复制代码

ziyunfei

1. awk -F"'" '/^\x27/{printf $2;FS=" - "}/^[^\x27]/{print  "\t"$1"\t"$2;FS="\x27"}'  file

复制代码

liaoboda

回复  liaoboda

没看清，原来还要删'号
ywlscpl 发表于 2011-06-29 17:04

多谢了! 但是这个还是有一点问题的 第一行是搞不出来的

liaoboda

ziyunfei 发表于 2011-06-29 17:08

    多谢了!这个第一行也有问题,不过把引号和冒号去了.但是$2 和$3的间距不够,我下边的awk不好区别了

ywlscpl

回复 8# liaoboda


    ywlscpl@ubuntu:~$ cat file
'123456':
AVD - dfdsa dsfsdf fklsdfjsa;fsafsfsf
'234456':
CDR- dfasfsadfsad dsaffsdfsadfsf
ywlscpl@ubuntu:~$ awk -F "'" '$0~"^"FS{printf $2" ";next}{sub(/-/,"")}1' file
123456 AVD  dfdsa dsfsdf fklsdfjsa;fsafsfsf
234456 CDR dfasfsadfsad dsaffsdfsadfsf

TasteOracle

回复 9# ywlscpl


    这个只是楼主举的例子，实际上他还是想处理顶楼的那些数据