Shell Programming and Scripting

run it without redirecting to a file first.

runs just fine under Solaris' 'nawk' and the sample files previously posted. Check your input files

file1 :-
1000*Interest Income*2006*100.00
1005*Rental Income*2006*0.00

file2:
BR1*2006*1000*00002*01/03/2006*USD*36.65
BR5*2006*1005*00001*01/04/2006*USD*2000.00
BR1*2006*1000*00005*01/14/2006*USD*150.00

i am using above files as input files and getting following output after the same script


Opening Balance :100.00
01/03/2006 USD 1000 36.65
01/14/2006 USD 1000 150.00
Total Balance : 286.65

Opening Balance :0.00
01/04/2006 USD 1005 2000.00
Total Balance : 2000

If there any problem in input files please prompt me.

---------------
Ajay

prompt: your input files are missing HEADER lines as you had them in the original one.

if you're NOT going to have header lines, then delete line

Code:

FNR == 1 { next }

Thanks Ajay and Vgersh! You guys are great!

I have obtained the output now.

$ more result1
Opening Balance :100.00
01/03/2006 USD 1000 36.65
01/14/2006 USD 1000 150.00
Total Balance : 286.65

Opening Balance :0.00
01/04/2006 USD 1005 2000.00
Total Balance : 2000

Many thanks!

I am pasting the output obtained by the awk command. I did not have nawk, so I ran it with awk:

$ awk -f aug.awk file1.vg file2.vg

Year: 2006 GL number: 1000 GL name: Interest Income
Opening Balance: 100.00

Posting date Currency TransID Amount
01/03/2006 USD 00002 36.65
01/14/2006 USD 00005 150.00

Total 286.65

Year: 2006 GL number: 1005 GL name: Rental Income
Opening Balance: 0.00

Posting date Currency TransID Amount
01/04/2006 USD 00001 2000.00

Total 2000.00
=============================

Once again thank you to everyone who contributed and I am closing this thread.