This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Copy column to another column in the same file

I have a gff3 file with 9 columns, I want to copy the 9th column and its content to column 2 of the same file so column 2 and 9 will look identical. Was hoping if there is a way to do that. Appreciate all the help.

chip-seq
• 1,212 views • link
updated by jared.andrews07 jared.andrews07 • written by mropri mropri

1 answer 

awk -F "\t" -vOFS="\t" 'NR==1{print} NR>1{print $1,$9,$3,$4,$5,$6,$7,$8,$9}' my_gff3_file.gff
• 0 views • link
written by Ram Ram

Thank you for your help. It works, but how do I make the change permanent.

• 0 views • link
written by mropri mropri

Pipe it to a new file by tacking > your_new_file.gff on the end.

• 0 views • link
written by jared.andrews07 jared.andrews07

Thank you very much!

• 0 views • link
written by mropri mropri

Log in to answer this question.

More posts like this