You were right I need to match the fourth element against each of the records. I added the code you suggested and no value was returned
I decided to do a check and I did this:
foreach my $records (@merged_array) {
my @elements = split /,/, $records;
print $elements[0];
The Output from this was:
"John Doe"John Doe"John Doe"John Doe"John Doe
I realized that some of the fields themselves had commas within and that I couldn't consistently get the field I wanted by "print18" in this case
So back to the drawing board for the next few minutes