Hi there,

I am having an output file resulting from a script, this output file looks as follow:

10 Account1
20 Account2
89 Account3

Now i have another file which includes all the accounts (i.e. all acounts which have records in the mentioned output file and the rest of acoounts which have no records)...what i want to do is the following:

I want to generate a final out put file which have all the accounts and near to each account it mention the total number of recrods resulted from the above output fle, and if there is any account which have no records in the above output file, then in the final output file the value near to that account shall be 0

Any idea how to do that??

Thanks in advance.

nawk -f char.awk fileFROMscript fileWithAllAccounts

char.awk:

# for the FIRST file specified on the command line....
# build array 'arr' indexed by the values from the SECOND column AND 
# the accumulated values from the FIRST column.
FNR==NR {arr[$2] += $1; next }

# for the SECOND file specified on the command line......
# print every record.
# if the value of the FIRST column appears as the INDEX in 'arr' - print the 
# 'value' from 'arr'. Otherwise print '0' .
{
   printf("%d%s%s\n", ($1 in arr) ? arr[$1] : 0, OFS, $1)
}

How will be the output of the file wich has all the accounts?

Accoun1
Account2
.....
.....

I think that i can do with a shell script but it is longer than nawk

Bye

It will just include the name of the accounts in one coloum (this file name will be output1).....and as i explained before, i am having also another file resulted from a shell script (output2)which have accounts and their records but for sure not all accounts listed in the above file (output1)....so its like a comparison between output1 & output2......all the accounts mentioned in output2 along with their records will be displayed with no change, for those accounts which are mentioned in output1 but are found in output2 will be diplayed with number "0" displayed near them.......
Hope i explained it in a good way...Thx

If you dont mind, can you explain to me how does the below work, i am not that much expert in unix. I want to try it but at least i need to understand what each parameter mean so that i will be able to load it to my script.



Thanks for your help.

added comments to the original post.

what about if the output files are of the following format:

Account1 10
and so on.....then what fields to be interchanged in your command?