Hello Visoveemr and Penguin8R,
Sorry for such a late reply. What you both say sounds promising and I am interested.
I think I am going to do Penguin’s instructions first since that seems easiest to perform. Lucky enough, the file names already have the patient chart numbers in them. I just have to remove the inconsistencies that are in the files. Penguin, when you say PID, do you mean patientID or primary ID?
UPDATE: Penguin8R, you are the man/woman! This is exactly what I needed. Now I just need to figure out how to do all of this. lol! But that is the fun part!