I'm looking for method/way to rename files/folders
I have a collection of about 70 folders with a structure of 9 subfolders consistant between each.
Currently looks like:
FOLDER
SUBFOLDER A
SUBFOLDER S
Each of these subfolders needs a ##_ added to the beginning of the folder name.
FOLDER
01_SUBFOLDER S
02_SUBFOLDER A
Is there a way to do this? Can it be done in a bulk SQL query (i.e. update folder_table set folder_name="01_subfolder s" where folder_name="subfolder s")?