Shell Programming and Scripting

Hey all,

I am haivng n number of files all of them are of the same format but different details. i.e

File1 is having the folloeing details:
"Account1",123
"Account2",10
"Account3",12355
"Accountn",555

File2 is having the folloeing details:
"Account1",1234
"Account2",100
"Account3",2290
"Accountn",679

and so on.....so as you can see i am having n number of files, all files have the same account number inside and the only difference is in the number of recrods each account has in each file.....Now what i want to do is to generate a final file which will have all the accounts mentioned earlier along with their records, it will be somehow i a table format.i.e.:

Final output file should look like the following:
"Account1",123,1234
"Account2",10,100
"Account3",12355,2290
"Accountn",555,679

Any idea on how to do this?

try something like this

Code:

awk -F"," ' 
{ arr[$1]=arr[$1] FS $2 }
END{
for key in arr
{
print key "," arr[key]
}
}' *

anbu23,
have you tried you solution?

nawk -f char.awk file2.txt file1.txt

char.awk:

Code:

BEGIN {
  FS=OFS=","
}
FNR==NR { arr[ $1 ] = $2; next }
{ print $0, arr[ $1 ] }

Code:

join -t"," file1 file2

A variation of anbu23's script, which is what I think he was attempting (less syntax errors )

Code:

nawk -F"," '
    BEGIN { FS=OFS="," }

    { arr[ $1 ] = (arr[ $1 ]) ? arr[ $1 ] FS $2 : $2 }

END { for (i in arr) print i, arr[i] }
' file_1 file_2 file_n

This solution allows for any number of files beyond file 2.

I didn't test my code.