The other part of the earlier project, which you will need to give me an additional price for as I do not expect you to do this for what you bid, is that I need to access a database table (on my site it is an Oracle table) but you can create a simple Access DB to similate it and use an ODBC data source connection. I only need two columns one has the project numbers (that match the project numbers in () in the .pdf file names) the other has another value which needs to be added the file names.
original file name = 1st St ES RHU (325Q5-1) [url removed, login to view]
it needs to be changed to PFF-(325Q5-1)[url removed, login to view]
The ZY comes from the DB table row that's value matches the project number 325Q5-1; it is the value in the second column.
Let me know if you understand.