Hi,
I have a requirement wherein, I've to rename filename column within the database with new one.
eg Sample.doc should be Sample_New.doc
or ReadMe --> ReadMe_New
Some sample list of filename that we have are with extensions and some are without extension
FileName
this.is.sample.pdf
this.is.just.a.doc.file.docx
IamTrickyPDF
Expected
this.is.sample_New.pdf
this.is.just.a.doc.file_New.docx
IamTrickyPDF_New
this.is.sample.pdfthis.is.just.a.doc.file.docxIamTrickyPDFEthis.is.sample.pdf
this.is.just.a.doc.file.docx
IamTrickyPDF