Hello,
I assume that you are able to get the o/p in a plain file. Here are the steps that you should follow:
- Initiate a counter from 1
- Loop through the file line-wise
- Operate on current line according to value of counter
- Increment counter; reset to 1 if value is 6
Actions according to value of counter:
1 this is ur database
2 this is ur filename
3 take col 4 and 5 - use awk or cut
4 same as counter value 3
5 this is the status (I would take "Successful"/"failed" only)
at each step echo these values and use tabs to separate them, eg:
Code:
echo "\t<value>"