I am running a csh script that runs and does various things. I finally want to do some multiplication.
This is the code I need to run within my csh file.
{
Totals[$5] += $3*$4
}
END {
for (x in Totals)
print i, Totals[i]
}
Right now I have to run this on a separate file for it to work. So...
Yes they do, that's how it is presented. I tried doing join but it doesn't seem to work since the field separators are different. What I would like to do is do a join, then use variables for each space, maybe to do a find/replace so I can make them all the same.
Does that sound like it would...
I tried a AWK command but I got syntax errors. I didn't get far enough to get any results.
I need to get totals from each employee on sales.
Could I do a JOIN twice, then do some kind of math?
Thanks,
Mike
I'm having trouble with using the AWK command.
I have 3 tables
Employee Table
21/John Doe/39000/Clerk
21 is the employee ID,
Sales Table
104,9,03:01:2007,21
104 is the item ID, 9 is the quantity, and 21 is the employee ID
Products Table
104:fishing line:0.99
104 is the item ID and 0.99...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.