I have a big text file (3G) that look like this:
150105 00:04:17 ACTIVATE_SUBSCRIPTION COMPLETE
150105 00:12:38 ACTIVATE_SUBSCRIPTION COMPLETE
150105 00:02:36 ACTIVATE_SUBSCRIPTION COMPLETE
You have in each line 3 columns: a timestamp, type and status.
As you can see in the time stamp part I have a date in the format as YEAR/MONTH/DAY.
What I need is a count for the total of lines I have for each type (in the example lines above is ACTIVATE_SUBSCRIPTION) and for every type a count for each status (in the example above is COMPLETE).
The possible types are:
And the possible statuses are:
The timestamp goes through 150105 to 150109.
So the output should look like this:
<the count of lines like this>
,<the count of lines like this>
the count of lines like this>
S,<the count of lines like this>
A sample of the file is attached.
Pls skip the first 5 lines of the file if possible...
Is this possible to be done?