 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Programming / January 2006Mass document edit
A colleague has two years worth of documents that they want to import into their EMR (Electronic Medical Records). The EMR has an import function that reads the first few lines of each document to route it to the correct patient, encounter date, provider/doctor... The documents in question were created w/o knowing the exact format of the lines used to route the document. Is it possible to do a mass edit that will replace text in the current documents with the correct equivalent. The documents must be saved in RTF Format, and the first page should have first lines in this format Line 1 is blank PATIENT MRN:000000308328 DATE: 01/06/06 DESCRIPTION: TRANSCRIPTION PROVIDER ID:0A745553-9541-4281-BD42-EEB58D4514DC I'm not expecting code from someone to fix the existing documents, just wondering if it's possible and a reference to refer to. I will not be fixing these, I'm just posting the question for a colleague.  SignaturePatrick Rouse Microsoft MVP - Terminal Server http://www.sessioncomputing.com Hi Patrick, It might be. To open all documents, see the article "How to read the filenames of all the files in a directory into an array" at http://word.mvps.org/faqs/macrosvba/ReadFilesIntoArray.htm If it's a directory structure, then the article "How to get the names of all the folders in the folder tree, starting from a specified folder" at http://word.mvps.org/faqs/macrosvba/ReadFoldersIntoArray.htm To do the replace, have a look at the article "How to Find & ReplaceAll on a batch of documents in the same folder" at http://word.mvps.org/faqs/macrosvba/BatchFR.htm Hope this points you to some useful resources. Dave > A colleague has two years worth of documents that they want to import into > their EMR (Electronic Medical Records). The EMR has an import function that [quoted text clipped - 17 lines] > wondering if it's possible and a reference to refer to. I will not be fixing > these, I'm just posting the question for a colleague. It depends on how the documents are structured. In principle, the answer is yes: you can certainly write a macro that will open each document in turn, make changes, and save as RTF. The challenge is whether the required information (Patient MRN, Date, etc) is easily identifiable, which depends in turn on how the original documents are structured. >A colleague has two years worth of documents that they want to import into > their EMR (Electronic Medical Records). The EMR has an import function [quoted text clipped - 20 lines] > fixing > these, I'm just posting the question for a colleague.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.