This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Removing text after last underscore on given column

Hey guys,

I have a tab-delimited file like this 

NZ_CP007546.1_En_asburiae4561905        434     17636
NZ_CP007546.1_En_asburiae4561905        85823   93173
NZ_CP007546.1_En_asburiae4561905        178912  203202
NZ_CP007546.1_En_asburiae4561905        313008  317041

...

I want to remove text after the last underscore on the 1st column, so that I have

NZ_CP007546.1_En        434     17636
NZ_CP007546.1_En        85823   93173
NZ_CP007546.1_En        178912  203202
NZ_CP007546.1_En        313008  317041

I know that I can use sed to do that, but when I use sed -i 's/_[^_]*$//' it removes all the text in the same line, and my goal is to do that only for the 1st column. Thanks!

sequence
• 1,970 views • link
updated by JC JC • written by genomes_and_MGEs • genomes_and_MGEs

2 answers 

cat in.txt | rev | sed 's/\t[^_\t]*_/\t/'  | rev

EDIT:

sorry: much simplier is 

sed 's/_[^_\t]*\t/_\t/' < input.txt
• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum 
perl -pe 's/(_\w+)_\w+/$1/' < in.txt
NZ_CP007546.1_En        434     17636 
NZ_CP007546.1_En        85823   93173
NZ_CP007546.1_En        178912  203202
NZ_CP007546.1_En        313008  317041
• 0 views • link
written by JC JC

Log in to answer this question.

More posts like this