Compare one of the columns of two seperate files and write the raw of the second file next to first file if match.
What I want to do is that I have two files File1.txt and File2.txt. I want to compare third column in File1.txt and second column in File2.txt. If found a same value write the raw of the second file next to the corresponding raw of the first file (if not remain empty, or put ".")
Thank you for your answers.
File1.txt
1 2 A 3
4 5 A 6
7 8 B 9
10 11 C 12
File2.txt
13 A 16
14 B 17
15 D 18
Output.txt
1 2 A 3 13 A 16
4 5 A 6 13 A 16
7 8 B 9 14 B 17
10 11 C 12 . . .
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Understanding Uncommon Genotype Formats in VCF Files Generated by nf-core RNAvar Pipeline
written by ASid •
-
How to label columns in HTSeq output
written by mrs97 •
-
Creating column that groups data from another columns
written by Bioinfo •
-
Problem with design for DESeq2
written by 5cantaloupe5 •
-
New Column based on another data frame
written by j.lunger18 •
-
Count columns and delet specific one
written by salvatore_d •
-
MGRA returns error
written by little_more •
-
ComBat on TCGA RNAseq data generates all NAN
written by mforde84
-
how to compare sets using python (dealing with PDB file)
written by Jason Lin •
-
Split Seven Rows In Per Column
written by 2011101101 •
Really? Compare one of the columns of two seperate files and write the raw of the second file next to first file if match.
And why next-gen tag?
People are wondering where to answer, when they have seen a same question 2 times asked by one person :)
I understand, how can I delete this post
There is a
moderateoption below your post, go there and find delete