UNIX for Dummies Questions & Answers

Originally Posted by Don Cragun

This is a result of what is known in the trade as GIGO (garbage in, garbage out). You told us what your input files looked like and you told us what you wanted your output to look like based on those input formats. We provided you code that performed the requested transformations and gave the exact output you said you wanted based on those input file formats.

Now you show us an input file format that is completely different from your sample input file format for file1 and tell us that our suggestions didn't work. Our software isn't smart enough to magically realize that the input format for file1 was totally wrong and transform itself into new code that can handle your new input file format.

Next time please give us representative sample data instead of wasting the time of all of the volunteers who were trying to help you.

I have other things to do this afternoon, but I may be able to try to put something together later to work with your new input input file format.

Originally Posted by RudiC

Absolutely! It's so frustrating to produce sth and then find out its useless 'cause its based on wrong information.

Originally Posted by Don Cragun

With your new input file format, the following seems to work:

Code:

awk '
FNR == NR {
        key[$1]
        next
}
{       for(k in key)
                if(index($2, k)) 
                        key[k] += $4
}
END {   for(k in key)
                printf("%s (%.1f)\n", k, key[k]) 
}' file2 file1 | sort -t'(' -k2,2n