Hello @richgalloway , I am asking your help again to get counts for below messages. I tried the same instruction but unable to get counts. From below messages get counts depends and message value. Your help would be highly appreciated. Consider message which ends with To Report. and get counts. message contains "Parker could not be processed" - Failure count message contains "Parker successfully issued" - Success Count if message has Any other message : Partial Success get total count Total Count. PK11036791 : Parker successfully issued the 06/05/2021 renewal.,.To Report. PK11036918 : Parker successfully issued the 06/05/2021 renewal.,.To Report. PK11037082 : Parker successfully issued the 06/05/2021 renewal.,.To Report. PK01041601 : New activity on DRA for Michael Demiranda.,Please review new MVR information.,New PPA changes present.,Multiple Property policies present, please work HO.,.To Report. PK11032274 : Please review new MVR information.,.To Report. PK11036998 : Parker successfully issued the 06/05/2021 renewal.,.To Report. PK11041586 : New HO changes present.,Please review new MVR information.,New PPA changes present.,.To Report. PK11004163 : New HO changes present.,New PPA changes present.,.To Report. PK11014724 : New PPA changes present.,.To Report. PK11041665 : New HO changes present.,Please review new MVR information.,New PPA changes present.,.To Report. Parker could not be processed, please work PK Renewal. To Report. Parker could not be processed, please work PK Renewal. To Report.
... View more