> 2. If I have the C_ID of the customers in a separate csv, is it
> possible to compare the C_ID with that of the C_ID in the dump and
> determine the sum of stat1, vol2, amount3⦠(sum of the fields
> only for a set of customers and not for the ID_NOs in whole)
If you looking for throw away script, then just use this:
$ join cid.txt cid-dump.txt -t, > tmp
$ awk '{print $1 "," $2 "," $3+$4+$5}' tmp > result.txt
Bye :)
--
Bharathi S
_______________________________________________
To unsubscribe, email [email protected] with
"unsubscribe <password> <address>"
in the subject or body of the message.
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
