Reading logs with text format and showing the count of success and failure

I am trying to read the log file given as text file.I need to take the count of success and fail lines and capture the reason for that, which is in the same line where we have succes and failure message.

eg.
20170506-09:20:38 Failed Refresh for MV: MV_SEARCH_FFL_HISTORY$A # Error Reason : ORA-00942: table or view does not exist

So i should get "MV_SEARCH_FFL_HISTORY" failed due to "ORA-00942: table or view does not exist".

Above two things under 2 new fields that is "Status" and "Cause"

What have you tried so far?
What errors are you getting?

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.