AWK - Assume the code you are writing is in an awk script file.

Data file with the following format :
Check#, date, payee, catagory, amount

Data sample :
,2014-01-06,Aldis,Food,26.76
3048,2014-01-06,Bob's Heating,Home,468.23

Code the awk statement that sets the field separater to a comma, before processing records.

Code an awk statement that tests, in the pattern area before the action block, the 1st field. If it has a check number, all digits, sum the amount.

Write an awk statement that accumulates the amount in an associative array that is keyed on the catagory field.

Write an awk statement that runs after the records have all been processed, this will print the catagory and the sum for each catagory. Use formatted print so it looks nice.