I have a folder with many text files in it. Each file contains the following 7 lines:
CHART #: 3563A
PATIENT NAME: Joan Q Public
NOTE DATE: 09/26/2007
Note for Joan Smith on 9/26/2007 - Chart 3563A
The File names contain a sequence number followed by the value in CHART #: I need to renname each file using a vbscript by appending the line starting with NOTE DATE to the current file name.
The above file would be named 1234_3563A NOTE DATE: 09/26/2007.txt