I have 20,000 documents scattered across multiple folders that I need to have copied to a new location and renamed with a file extension. I would like to have a script that can read an Input file and perform the function accordingly.
Example of original files:
Example of comma delimited input file contents (called C:\Input.csv)
PDF,F:\000100\203010\G3.FB,Invoice from ABC
DOCX,F:\090320\134010\X7.6P, Letter to Susie
HTM,F:\012050\761010\5V.J1,Bank Rec Report
I would like to have a script that will read the input file and copy & rename the files to the G" drive in the following format:
We are essentially adding the appropriate file extension to each file (as referenced in the Input.csv file), and copying the document to the G: Drive