I need to search a document for a few details which are being scraped from another document.
For example in Document 1 I scrape that the name is “Joe Bloggs”. I then store this in variable Name and then use that variable to search the next document. If the document contains “Joe Bloggs” then I can say they are a match, but I would also like to be able to mark it as a match if it searched “Joe Bloggs” and came back as a match if it found "Mr Bloggs " in the document or “Joseph Bloggs”.
I can’t split the string as the name comes up in various locations so I am never actually saving the second name to a variable, simply using the variable from the first document to search for the name in the second document.
Any ideas welcome!