help
i want to Create a project that will read a textfile. In the textfile consists of a record of account number, debit or credit and amount of transaction.
You are to read the text file and put the data into an array. Search through the array and find the largest amount of deposit (credit) and largest amount of withdrawal (debit).
The format of the file called “transaction.txt” is:
accountnumber,dr/cr,amount
The delimiter is a comma.
You need to print preview all debit and credit transactions, separately, the total for each, FOR EACH ACCOUNT.
Display ON THE SCREEN the total number of transactions for debit and credit, the account number of the largest withdrawal and largest deposit.
Use Functions and Procedures where applicable.
DELIVERABLES:
1. Print Screen of the outputs (SCREEN OUTPUT and PRINT PREVIEW)
2. Printout of the coding
Example of Print Preview
Debit Transactions
Acct No. Amount
010010000130 30.00
50.00
Total 80.00
010010000234 40.00
Total 40.00
Grand Total 120.00
Credit Transactions
Acct No. Amount
010010000130 45.00
Total 45.00
010010000234 30.00
130.00
320.35
Total 480.35
Grand Total 525.35
transaction
010013110325,dr,190.00
010013942855,dr,29.00
010014499846,cr,300.00
019094989982,dr,390.00
020994888752,cr,988.00
094099888029,dr,39000.00
010013110325,cr,398.00
010014499846,dr,388.00
090998847745,cr,4039.99
010014499846,cr,399.00