Commission Disclosure Enquiries From MSE and how to RPA them.........

Firstly start with sending yourself every variant of the selections on the page.

From the website and using the various dropdowns you end up with a definitive list of variants that should appear in the email start here:https://www.moneysavingexpert.com/reclaim/reclaim-car-finance/

Step1

List the variants you see in a big list i.e.

Essentially every version of this:

Details that may help you find my policy:

Name:
testy mctest

Date of birth:
01/Jan/2004

Current address:
010 RPA ROW


Finance agreement policy number: 
123456

Vehicle number plate:
-


My address when I had the finance this complaint relates to:
101 RPA ROW


Yours sincerely,
testy mctest

 

E.G.

Name:

Date of birth:

Current Address:

The rest is where the variants begin so will stop here not going to give it away :D

For a dumb robotic process to have a chance at understanding what parts of the email it needs to chop and return the data for based on just those first 3 are:

Table (1 column)

TEXT_TO_FIND

Name:

Date of birth:

Current Address:

We know that after yours sincerely the name should be in the section under Name:

We need to loop through our known variants of the text: and when they are not present filter them out of the known table of variants.

Now we have a list of what is there so we can now split between row 0 and row1, etc until all the data is pulled out between the known pieces of text.  For each block of text you can further improve this with Regex to get Car reg and addresses.

Start my split at Name:, end it at Date of birth: the result is testy mctest

Next split Date of birth: next line is date of birth.

By simply finding all variants and listing them we can loop through that and check which ones exists in the text toi then split by those in order to pull back the data on next row.

 

We need your consent to load the translations

We use a third-party service to translate the website content that may collect data about your activity. Please review the details in the privacy policy and accept the service to view the translations.