SovietRussia Posted May 21, 2015 Posted May 21, 2015 Hi, Need to export some student reports but I need to change the name of the file that is exported, is there a way of doing this? It currently shows up as Profile of 10 Year Autumn 2014 [surname] [Firstname] [AdNo.] and I need it as year_surname_firstname_adno Cheers, SR
vikpaw Posted May 21, 2015 Posted May 21, 2015 There are a load of ways, i've used several over the years. Currently, I would export them and then run a rename tool over it. Either write your own in dos or vbscript, or use a tool like the Bulk Rename Utility Introduction - Bulk Rename Utility I use it all the time, it takes a text file as input with 'before name | after name'. The file can be easily created in Excel. I usually start with a dos command on the folder like dir /b /w *.doc > list.txt to get the start names, then use formulae in Excel to rejig it, there are way smarter ways, but for the time it would take me to write and troubleshoot a script, i'd just do a rough and ready way like this: =SUBSTITUTE(RIGHT(A1,LEN(A1)-31)," ","_") Add to the beginning the year using '&' or concatenate formula, then in another cell copy as text, and concatenate with the original version and a | in between - assuming you want to use that utility. Other ways, you can just do a for loop in dos over the text file with old and new names in. 1
Recommended Posts