• Read perlintro
• Write some code.
• Post back here with specific questions about your code, if necessary.
• Read How do I compose an effective node title?

Also, please read about use of code tags for DATA as well as for code. As you've presented your data, we cannot readily distinguish between a space and a tab. See Markup in the Monastery.

AFTER the http://perldoc.perl.org/perlintro.html toolic cited (and which is available from the command line on your own machine (eg: C:\ perldoc perintro<CR> on a Win machine or at your bash (etc) prompt on a *nix-ish box), assuming you've installed any standard Perl), you may wish to visit our well-stocked Tutorials, starting with those on reading from a file.

First, read Markup FAQ to help you format your posts. Of course "Help" as a title is not "helpful" to us.

You don't say what if any programming experience that you have although your post alludes to the idea that you have some other way than Perl to solve this problem.

In general, I would recommend a 3 stage approach:

1. Write program to read file 1 and parse it correctly
2. Write program to read file 2 and parse it correctly
3. Then combine prog1 and prog2 and start making decisions

#!/usr/bin/perl
use warnings;
use strict;

open FILE1, '<', "file1name" or die "input1 error $!";
while (my $line = <FILE1>)
{
  chomp $line;  #remove line endings
  my ($name1,$name2,$name3,$name4,$name5) = split ' ',$line;
  #use some names that describe what you columns really
  #mean usually col1, col2 is a bad idea.
  
  # put some print statements here to make sure that
  # you can actually get the 5 individual things
}
[download]

my ($nameOfNumberfield1, $nameOfNumberfield1, $nameofTextField,
$nameofTextfield) =split ',',$line;
[download]

Make a stab at the combined program 3 and let us know what issues you are having. If line 5 of input 1 always goes with line 5 of input 2, then this is much easier than a more general situation, but I can't tell from your description what the full requirements are.

I hope that my advice on some of the basics: (a) open the file, (b)basic parsing can get you started? Read about file open and split. Good Luck on your journey, it will require a lot of work.