When I use the write line I get this in the output
“This is the doctors name” + DoctorName(0).Value
Dr.Smith
It seems to get the right file to overwrite
what file is this - files\Output\Patient Satisfaction Quarterly Provider 2022_1.pdf
This is what I have in the To: “files\Output" + DoctorName(0).ToString.Replace(”_“,”") + “.pdf”
In your write line you are getting Dr.Smith but in the above expression you are replacing “-”, what is the reason behind this operation? Probably you have to replace"." here
Put these expressions in write line and share us the output screenshot
Write line 1 : “files\Output" + DoctorName(0).ToString.Replace(“.”,”“) + “.pdf”
Write line 2 : “files\Output” + DoctorName(0).ToString.Replace(”_“,”") + “.pdf”
Thanks for the help the comma was giving me the issues so I cleaned up the data using an assign and used the clean data string to rename the PDF files. "files\Output" + strCleanPath + “.pdf”