merging table columns
I'm working in Linux with a large table of the following layout:
1 123456
2 234567
3 345678
And I would like to merge the columns, producing the following in a new file:
1_123456
2_234567
3_345678
Can anyone help?
Thanks!!!
• 826 views
•
link
0 answers
No answers yet.
Log in to answer this question.
Hello cjmcdermottroe!
We believe that this post does not fit the main topic of this site.
I'm closing this question as it's not related to bioinformatics. The answer to your question is tr https://linux.die.net/man/1/tr
For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.
If you disagree please tell us why in a reply below, we'll be happy to talk about it.
Cheers!
Sorry, I should've added more details. The table relates to genotypes. The first column is chromosome numer and the second is SNP ID. The table was generated using vcftools but requires further formatting before it can be processed (using matrixeqtl) for identification of EQTLs.
Pierre, you're faster than me! :p