emma hodcroft

Overview

The user has two tab-delimited files with an identifying name/number in the first column. For example, two files with gene names and data about that gene. However, the two files contain different types of data, and the two files do not contain exactly the same list of genes. File 1 may have genes not in file 2, and vice versa. This program enables the user to search file 2 for only the genes in file 1 and create a file containing the data from file 2 for the genes found in file 1.

Instructions

SAVE A COPY OF YOUR ORIGINAL DATA AND ONLY WORK WITH THE COPY!

• Put both files in alphabetical/numberical order by ID or Name (first column)
• Run the program; the first file will be your 'File 1,' the second will be your 'File 2'
• Be sure and select whether your files have 'header' lines
• Then select what you'd like the program to do if corresponding data can't be found
(Note: if you select that your program has headers, it will fill all empty columns with the text you've chosen, to make it more readable as a table in R if your file doesn't have headers, it will simply add the 'NA' or your selection once.)

Download

Requirements: You must have Java installed on your computer. The downloadable .exe file will prompt you if you do not have a new-enough Java version installed.

.EXE file: (For Windows)
Download here
(Yes, the .exe was created with third-party software, credit to JEXECreator)

.JAR file: (For hardcore Java-ers, Mac, anyone who hates .exe)
Download here
(Lookup online how to run a .jar file on your respective system.)

Code never lies, comments sometimes do.