I have been trying on a banking application code in which I want to monitor transaction activity where you read through a list of transaction records and return account nos that have exceeded the threshold amount for a given date.

For this I created a dummy text file using streamwriter where in I have the transaction records maintained spaced out with \t
For eg: AccountNumber\tTransactionDate\tTransactionAmount

When I read I am not sure how to split and collect distinct account nos for a given date and calculate the transaction amounts to further verify if its above the threshold amount.

Any help with this will be highly appreciated.
Thanks in advance.