in reply to Merge 2 files using key field

So, let's nudge this along in a more healthy direction.

Surely you have code that reads the files. Can you show that?

Replies are listed 'Best First'.
Re^2: Merge 2 files using key field
by Jalcock501 (Sexton) on Nov 11, 2013 at 09:15 UTC
    Hi Marinersk

    I've managed to solve this now using awk instead. I know its not perl but for those interested here is how I did it.

    #!/usr/gnu/bin/gawk -f BEGIN { OFS=FS="," } { com="xchop -d, group.csv " $1 while ((com |getline res) > 0) { if (split(res,arr) > 1) print $2,arr[2] } close(com) }
    xchop is a C written function that acts as sort of a binary chop for strings.

    Thanks Jim