Hi all,
I have about 13,000 letters in MS word that I need to look for if they had pancreatic cancer. So there are some buzz words (pancreatic cancer, pancreatic adenocarcinoma, pancreatic tumor) in each of these 13,000 letters that I need to search for and identify them. It will be a tedious task for me to search and open each and every letter and then look for Pancreatic cancer.
Each of these letters are saved with patient’s name and date when they are seen.e.g doe, jane Jan 2016
I need help with the following:
1. Identify letters with pancreatic cancer and create a separate list (preferablly retain MS word format). These letters have name and date of birth, is there a way to select name and date of birth along with the pancreatic cancer?
2. Identify patients with multiple letters from the pool of 13,000 letters and save them in a separate folder. I need to isolate patients who had multiple visits, that is patients with more than one letter in the pool of 13,000 letters. If a patient had multiple visits (multiple letters), the name will be same but date of visit after name will be different reflecting their date of visit.
e.g doe, jane Jan 2016
doe, jane Mar 2017
All the letters are stored in one folder.
I would really appreciate any help with this.
... View more