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.
©Copyright. All rights reserved.
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.