Extract Desired Lines from a CSV file
This tool was created to use with GWorks but can be used more generally to find every line in the second file where the contents of a specific column matches a value in the same named column in the first file.
Select the CSV file with the column to match
[a GWorks m_ file]:
Select the CSV file to extract matching lines from
[a GWorks a_ file]:
The column name is assumed to be matchID (caps do not matter) unless you enter a different
column name:
(UPLOADING files takes a few minutes and this page does not change during that process ... look at bottom bar in your browser on the left side for status information, large files will take longer)
For GWORKS Users
The first file can be the match file (m_) or the match-o-matic result or any file with a list of match ids or names. That file is just used to collect the ids or names of the matches whose trees will be collected from the second file.
The second file should be an a_ file created from collecting ancestor trees. Only the trees which include the matchids from the first file are saved.
So for example with two half siblings looking for a shared parent
Run Match-O-Matic to get the common ids
Then use the tree file for one of them to create a tree file with only the trees in common.
In the case where a half sibling is looking for the parent not shared:
** Warning not all shared 4th cousins will match both half sibs. for better accuracy, set the cM threshold fairly high, 30-40 or so and exclude distant cousin matches when collecting the first person's match file with the client but include the distant cousins for the other person's tree file. That should take care of their differing match levels on the known side.
Use Match-O-Matic to get the matchids in A but not in B for the first file
For the second file use the a_ file for the person whose parent/ancestor you are looking for
Programming is how the author of this tool, Kitty Cooper, makes a living; so a small donation of $5 or $10 would be most appreciated if you find it useful.