i have about 3 files as txt in redhat but can also extract it to excel. it has about 3000 lines each, with values like date, iccid, command, status
how do i merge all these files, and get output like count of each iccid, no of commands executed for each iccid and its status. Thanks
apart from manual copy pasting of each file into excel, i was wondering if there is a regular expression or something like that to accomplish this. here is an example format
2024-05-26 11:27:24,<20 digit no>,messageId:success,statusWord:9000,command:delete
2024-05-26 08:57:51,<20 digit no>,messageId:success,statusWord:9000,command:delete
2024-05-26 01:09:24,<20 digit no>,messageId:success,statusWord:9000,command:install
2024-05-26 04:15:36,<20 digit no>,messageId:success,statusWord:9000,command:load
2024-05-26 23:03:26,<20 digit no>,messageId:success,statusWord:9000,command:load
2024-05-26 16:48:13,<20 digit no>,messageId:success,statusWord:9000,command:delete
2024-05-26 20:05:50,<20 digit no>,messageId:success,statusWord:9000,command:delete
2024-05-26 23:58:56,<20 digit no>,messageId:success,statusWord:9000,command:load
Avinash Purohit is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.