Welcome to Perl and the Monastery, Deicide!
Please have a look at How do I post a question effectively? and Short, Self-Contained, Correct Example: at the very least, please provide some sample input that demonstrates what you are describing, the expected output for that input, and if you have it, any code you've tried, plus the output you're getting from that code, including exact error messages. Each of these should be placed in <code> tags for readability.
In general, for handling CSV data, it's best to use a module like Text::CSV (also install Text::CSV_XS for speed). It sounds like you'll want to parse the first file, and as you're doing so, parse the cells in question using a regex - if the string you want to match on is always in parentheses, like in "first last(G123456)", the perhaps you could use Regexp::Common::balanced to help with that (but we'd need to see some more samples of input data to be sure). Then, assuming you want exact matches, perhaps you could build a hash of the values you've seen (with the keys being the values, for easy lookup), and as you're parsing the second file, look up matching strings in the hash. But this is just a rough idea based on the description you've provided so far, as you give more details, better methods might emerge.
In reply to Re: 2 files
by haukex
in thread 2 files
by Deicide
| For: | Use: | ||
| & | & | ||
| < | < | ||
| > | > | ||
| [ | [ | ||
| ] | ] |