I’m no script expert but I’ve started a small one that I want to use to parse the /var/log/asterisk/cdr-csv/Master.csv file. The trouble is this file is not consistent. For example it has 16 fields separated by commas. In some of the entries in field #5, the callerid may have another comma in it. And fields #11, #13 & #14 don’t use quotes. This of course makes it hard to do parsing using a sed and awk. At least with my limited knowledge it does.
Can anyone offer some advice on how to parse the * log file? Is there some script available to do this?