I would like to find someone to write a simple conversion tool. The basic function is to accept a a text (tab or comma delimited) file (see below) as the input, and generate a specific text format as an output. Plus it should be able to accept a filtering text file. It should be windows-based, and should process fast (i.e. no double looping). For many of you this would probably take only a few minutes... please read on if you're interested.
## Deliverables
I would like to find someone to write a simple conversion tool. The basic function is to accept a a text (tab or comma delimited) file (see below) as the input, and generate a specific text format as an output. For instance Input file "A" "B" "C" "D" "E" "B" "A" "D" "C" "D" This input file means "A" likes B, C, D, and E; B likes A and D; C likes D. Note that the first ID in each row is the "center" and the relationship is directional. output file should be like this - *Vertices 5 1 "A" 2 "B" 3 "C" 4 "D" 5 "E" *Arcs 1 2 1 3 1 4 1 5 2 1 2 4 3 4 In addition this program should allow me to impose a filter. This will be an additional input file - a one-column list e.g. "A" "B" And the program should allow me to choose whether to "keep" this list or "drop" this list after comparing with the input file mentioned above. More specifically: If I choose "Drop" then it will go through the file above and drop all those in this list. In addition, if one of these shows up in the first column in any row, that entire row should be removed. i.e. if "A" "B" is on the "drop" list, the above sample should now only have this row left "C" "D" (This need not be an output) And the output should be *Vertices 2 1 "C" 2 "D" *Arcs 1 2 If, instead, I choose "KEEP" for the same file, then the above sample should become "A" "B" "B" "A" And the output should be *Vertices 2 1 "A" 2 "B" *Arcs 1 2 2 1 *** One important requirement: please do not use double-loop. I need to process files like this with over 50k rows and it would take days for each one of them if you use double loops. That would be it. I would like to have the source code. Windows-based GUI is preferable but Perl/python/java etc. scripting language is also acceptable. I believe this is very easy, so I hope you'll be able to finish it in a max of 4 days after I accept your bid. Thank you and I look forward to working with you.