I have a column in my table that has invalid file names. I need to rename the file names by replacing the last characters with a new value. And, I must do this for every record in the table.
So, I have the following value in the field:
123456_SM.jpg
And, I want to replace it with the following value:
123456_F_SM.jpg
Every value follows this format. Is there a simple way to accomplish this?
Thanks for your help!
Start Free Trial
