Re: Merge 2 files using key field

[marinersk]

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

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

[Jalcock501]

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