Hello,

I was just making a bash script to analyze a log file with three important things; acct, date and amount.
So the log file is like for particular date several accts do withdraw/deposit money. I parsed the file line by line and put all these values in array, thought it would be easier to manipulate later like this:
ACCT[]=holds all the account including duplicates
DATE[]= holds all the dates
AMOUNT[]= holds all the money figures

Now at this point, I have to rethink again as I cant correlate 3 of them as I don't know which acct withdraw/deposit money on which date or like if try to find out one particular acct withdraws on which dates/how much as there are no correlation now at this point.

Any ideas how to redesign this?

Thanks in advance.

Could be me but I'd use a simple, small database (SQLite3 should do) with epoch, account name, action, amount...

We can't tell you how to redesign it, until you show us what you have ALREADY designed. Also, you don't show us any samples of the input data, or what your goals are, so we can only guess.

A SQL database as suggested by unSpawn would be by FAR the best way to go, and writing a simple bash script to parse your existing log file and insert those records into a database would be trivial. If you just WANT a bash script, I'd suggest sorting the log file based on account number, which would give you a starting point. From there, read the array until that element changes, and perform some action.

thanks for the reply and ideas.
I switched from bash to python, the thing I am after bash will be overkill.

Thanks.