UNIX for Advanced & Expert Users

I have a file in the following Format

Fundid: 100-BankA

AccountNumber Balance
1 200
2 300
3 400


FundId:123321-BankB

AccountNumber Balance
1 200
3 100


...........

I can have N number of funds.

The final file should be one file having all funds data having three columns with Fundid being the third column

Any inputs how to do this


Thanks

Try this:

Code:

awk -F':' '!/^$/&&!/Account/ {if($1=="FundId") awkfundid=$2; else print $0,awkfundid}' filename_to_process

Note that I am assuming that the word 'FundId' will always have uppercase F and I.