manipulation of text by sed command

Question

I a file containing the genome ids following NZ_FLAT01000030.1_173 I need to manipulate those ids like this one: NZ_FLAT01000030.1 I tried some but didn't give me the exact thing.

sed 's/_/\t/' output : NZ FLAT01000030.1_173
sed -r 's/_//' output: NZFLAT01000030.1_173
sed -r 's/_//g' output: NZFLAT01000030.1173

How can I do that by using sed command?

Answer 1

$ echo 'NZ_FLAT01000030.1_173' | sed 's/_[^_]*$//'
NZ_FLAT01000030.1

Answer 2

Are you trying to remove the undesrscore and the digits following it?

echo 'NZ_FLAT01000030.1_173' | sed -E 's/_[0-9]+//g'

NZ_FLAT01000030.1