Hi,
I'm new to perl, and need help about comparing 2 columns within 2 different .tsv files.
I have search through the forum for some similar case of mine, such as [url]http://www.daniweb.com/software-development/perl/threads/335711[/url], [url]http://www.daniweb.com/software-development/perl/threads/336421[/url] and [url]http://www.daniweb.com/software-development/perl/threads/311399[/url] , I have tried to modified them according to my needs but somehow the final output is not right, so I decided to make a new thread.

I have 2 input tsv files,
The first one is archive.tsv. It is a paper database with the format of
[B]<Paper ID>[/B]\t[B]<Paper Title>[/B]\t[B]<Author>[/B]\t[B]<url>[/B]
[ICODE]P08-1016 Lexicalized Phonotactic Word Segmentation Margaret M. Fleck [url]http://aclweb.org/anthology-new/P/P08/P08-1016.pdf[/url]
P08-1021 Correcting Misuse of Verb Forms John Lee; Stephanie Seneff [url]http://aclweb.org/anthology-new/P/P08/P08-1021.pdf[/url]
P08-1030 Refining Event Extraction through Cross-Document Inference Heng Ji; Ralph Grishman [url]http://aclweb.org/anthology-new/P/P08/P08-1030.pdf[/url]
P08-1038 A Logical Basis for the D Combinator and Normal Form in CCG Frederick Hoyt; Jason Baldridge [url]http://aclweb.org/anthology-new/P/P08/P08-1038.pdf[/url]
P08-1039 Parsing Noun Phrase Structure with CCG David Vadas; James R. Curran [url]http://aclweb.org/anthology-new/P/P08/P08-1039.pdf[/url]
P08-1040 Sentence Simplification for Semantic Role Labeling David Vickrey; Daphne Koller [url]http://aclweb.org/anthology-new/P/P08/P08-1040.pdf[/url]
P08-1042 Ad Hoc Treebank Structures Markus Dickinson [url]http://aclweb.org/anthology-new/P/P08/P08-1042.pdf[/url]
P08-3003 Inferring Activity Time in News through Event Modeling Vladimir Eidelman [url]http://aclweb.org/anthology-new/P/P08/P08-3003.pdf[/url]
P08-5003 Semi-Supervised Learning for Natural Language Processing John Blitzer; Xiaojin Jerry Zhu [url]http://aclweb.org/anthology-new/P/P08/P08-5003.pdf[/url]
P08-5004 Advanced Online Learning for Natural Language Processing Koby Crammer [url]http://aclweb.org/anthology-new/P/P08/P08-5004.pdf[/url][/ICODE]
and the second file is program.tsv. It is a conference program database with the format of
[B]<Program Session>[/B]\t[B]<Paper Title>[/B]\t[B]<Author>[/B]
[ICODE]Information Extraction 2 Refining Event Extraction through Cross-Document Inference Ji, Heng; Ralph Grishman
Syntax & Parsing 1 A Logical Basis for the D Combinator and Normal Form ...

d5e5 commented: Good sample data and script wrapped in code tags. +9