Hey guys,
I have a text file containing transactions, one transaction each line.
I want to write a small script that sums up the amounts of each transaction.
The line format is as follows:
BANKACCOUNT TRANSACTIONID DATE SOCSECURITY NUM AMOUNT
The amount is always preceeded by at least 5 spaces, and nowhere earlier in any line are there 5 adjacent spaces. The amount is also always followed by ",00" which is irrelevant to the amount itself but might be useful when creating the script.
What language would be suitable for this? I really dont have any preferred language but would want this to be as simple as possible and preferably without having to set anything up on my (work) computer.
Any suggestions? Anyone feel like doing this