Altair slc extract key data from a very messy participation text report
Once you parse the text the computations are simple.
Too long to post here, see github
github
https://github.com/rogerjdeangelis/utl-altair-slc-extract-key-data-from-a-very-messy-participation-text-report
community.altair.com
https://community.altair.com/discussion/32928
https://community.altair.com/discussion/32928/monarch-exercise-31-ice-black-knight-msp-s-21k-participation-consolidation-of-remittance-analysis#latest
CONTENTS (Oncel you have parsed the report, the rest is trivial)
1 PARSE INPUT (CREATE TABLE PARSE)
2 How many accounts had Service Fees?
3 How many accounts have a Participation % that is not 90%?
4 How many loans have a Due Date that is > Paid Date