in reply to One to Many is Too Many?

DBD::CSV? It's not the fastest solution, but that shouldn't matter if it's one-time migration.

Replies are listed 'Best First'.
Re^2: One to Many is Too Many?
by Jamin (Novice) on Apr 23, 2008 at 13:07 UTC

    Thank you all for swift and easy to understand answers! It works! I knew there had to be an easier way to do it than I was. I was opening both files twice each. I think I was up to 40 lines.

    I based my solution on what Eimi Metamorphoumai proposed. Thank you Eimi!

    Here is what I ended up with

    foreach (@bz_comments){ ($who, $bug_id, undef, $date, undef, $body) = split(/,/, $_); $BZ_comment{$bug_id} .= "<p><strong>$who $date</strong></p> <p +>$body</p>"; } while (my ($id, $comment) = each %BZ_comment){ push(@bz_comments_OUTPUT, "$id , $comment"); }

    Thank you all again!

    Jamin