I have imported the text of medical letters into an access table tblLettersText. Each line of the letter is stored in a memo field LineText.
Each letter is electronically signed, and I wish to put the name of the signee/clinician into a field Clinician. Sometimes the name of the clinician appears on the same line/record that begins with "Electronically signed by". In many cases (well over 1000) the name appears on the next record. I can pick a lot of these up, as the line begins with Dr. , Mr., Mrs. etc., but sometimes the name appears without a title, e.g. John Brown.
How can capture these, to update the Clinician field accordingly? Is VBA the only way to do it?
Each letter is electronically signed, and I wish to put the name of the signee/clinician into a field Clinician. Sometimes the name of the clinician appears on the same line/record that begins with "Electronically signed by". In many cases (well over 1000) the name appears on the next record. I can pick a lot of these up, as the line begins with Dr. , Mr., Mrs. etc., but sometimes the name appears without a title, e.g. John Brown.
How can capture these, to update the Clinician field accordingly? Is VBA the only way to do it?