parse data in excel or using perl
Hi can anyone tell me how to parse a file which looks like this.
file1--
1
2
3
4
5
file 2
1 1234
1 7575
1 6467564
1 6473
1 2323
I need to compare this file and want to get a file like
1 1234 7575 6467564 6473 2323
Please do the needful...
• 1,244 views
•
link
updated
by
WouterDeCoster
•
written
by
sharmatina189059 •
•
written
by
sharmatina189059 •
0 answers
No answers yet.
Log in to answer this question.
More posts like this
-
Script for making exon file
written by harry •
-
How to check if a word is present in a column of a .ped file
written by Nuthatch •
-
Combining multiple bedfiles
written by ccagg
-
error while executing code for parsing genbank file
written by sharmatina189059 •
-
Retrieving protein protein interaction database using STRING database
written by sharmatina189059 •
-
How to create the taxonomy file for RDP Classifier?
written by muraliadithya315 •
-
Extract KEGG Enzyme data
written by sharmatina189059 •
-
compare and merge two txt files.
written by fufuyou
-
SwiftLink .dat format
written by wanabi •
-
Compare one of the columns of two seperate files and write the raw of the second file next to first…
written by emre •
Wwaat
Please put some effort into your question if you want to be taken seriously.
Please give a more clear example, your description is hard to understand.
I added markup to your post for increased readability. You can do this by selecting the text and clicking the 101010 button. When you compose or edit a post that button is in your toolbar, see image below:
Your question is completely unclear and the same for your example, it's not obvious how the data in file 1 and file2 should be compared. Spent some more effort in explaining what you have and what you need, if you expect an answer to this.
If you are limiting yourself to "excel or perl" then it's also a good idea to tell us why you cannot use anything else.
mergeor%in%thenpasteIn any case avoid using Excel for bioinformatics, and please update/edit your post with more clarification.
Hello sharmatina189059!
We believe that this post does not fit the main topic of this site.
Not a bioinformatics question
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!