Join two files with a common column
file 1:
V1
1111
2222
4444
file 2:
V1 V2 V3
a 1111 act
b 2222 asd
c 3333 qwe
d 4444 zxc
I want the output as:
V1 V2
1111 act
2222 asd
4444 zxc
I want to join the V1 column from file1 to the V2 column off file2, and get the desired output. Is there a quick way by linux commands to do it.
Thanks
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
awk command merge files on one common column
written by Confused_human •
-
Merging columns from multiple files and adding headers- Linux
written by tenten •
-
How to calculate average of each column and the data in separate file?
written by sadstudent •
-
Comparing values of a column if it falls between values of two columns of a different data set and …
written by eDNAuRNA •
-
Merge two files depending on multiple matching columns
written by iya837 •
-
How to replace row with another row in linux having NA and nucleotide bases
written by Kritika
-
R for loop
written by Kritika
-
compare and search a list of ids in two text file
written by Kumar
-
Compare one of the columns of two seperate files and write the raw of the second file next to first…
written by emre •
-
Split loop into chunks and execute in parallel in shell scripting
written by Bioinfguy •
you want join.
Hello glady!
We believe that this post does not fit the main topic of this site.
not related to bioinformatics
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!