Overclock.net › Forums › Software, Programming and Coding › Other Software › Batch Rename Program?
New Posts  All Forums:Forum Nav:

Batch Rename Program?

post #1 of 4
Thread Starter 
Hello,

I'm trying to do a batch rename of some files. I know there's a few batch rename programs out there already but none seem to have what I need.

I have a folder full of .html files that are in no particular order, that need no particular order. However I need then renamed to whatever names I have in a .csv, .txt, or any other sort of excel spreadsheet file.

Are there any programs that will grab whatever names/data I have in the excel spreadsheet and use it for a batch rename?
Intel Computer
(13 items)
 
  
CPUMotherboardGraphicsRAM
[i5 2500k] [ASRock Z77 Extreme4-M] [EVGA GTX 560] [Kingston HyperX 8GB] 
Hard DriveOptical DriveOSMonitor
[Samsung F4 320gb] [Lite-On 24x Combo] [Windows 7 Ultimate 64bit] [Samsung SyncMaster 941bw] 
KeyboardPowerCaseMouse
[Microsft ANB-00001] [SeaSonic 520w M12II] [ASRock Z77 Extreme4-M Box] [Logitech G700] 
Mouse Pad
[Walmart Brand - Cloth Black] 
  hide details  
Reply
Intel Computer
(13 items)
 
  
CPUMotherboardGraphicsRAM
[i5 2500k] [ASRock Z77 Extreme4-M] [EVGA GTX 560] [Kingston HyperX 8GB] 
Hard DriveOptical DriveOSMonitor
[Samsung F4 320gb] [Lite-On 24x Combo] [Windows 7 Ultimate 64bit] [Samsung SyncMaster 941bw] 
KeyboardPowerCaseMouse
[Microsft ANB-00001] [SeaSonic 520w M12II] [ASRock Z77 Extreme4-M Box] [Logitech G700] 
Mouse Pad
[Walmart Brand - Cloth Black] 
  hide details  
Reply
post #2 of 4
Found this how to article. Should do exactly what you need.

http://www.labnol.org/software/tutor...ogl-docs/2481/

Hope this helps!
Gaming Monster
(21 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-3930k ASUS Rampage IV Extreme EVGA GTX Titan SC 8GB G.SKILL Ripjaws X CL8 1600MHz 
Hard DriveHard DriveHard DriveHard Drive
256GB Samsung 840 Pro 128GB Crucial C300 SSD 60GB OCZ Vertex 3 SSD 1TB Samsung F3 
Hard DriveCoolingOSMonitor
6TB External RAID 0 EK Block, XSPC 3x120mm Radiator Windows 8 64-bit 34" LG 34UC87C-B 21:9 IPS LED Monitor 
MonitorKeyboardPowerCase
27" ASUS VG278H Filco Majestouch Tenkeyless Corsair AX750 Cooler Master HAF 932 
MouseMouse PadAudioAudio
Steelseries Sensei Steelseries 9HD Audio Technica ATH-AD700 Samson C01U Condenser Microphone 
  hide details  
Reply
Gaming Monster
(21 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-3930k ASUS Rampage IV Extreme EVGA GTX Titan SC 8GB G.SKILL Ripjaws X CL8 1600MHz 
Hard DriveHard DriveHard DriveHard Drive
256GB Samsung 840 Pro 128GB Crucial C300 SSD 60GB OCZ Vertex 3 SSD 1TB Samsung F3 
Hard DriveCoolingOSMonitor
6TB External RAID 0 EK Block, XSPC 3x120mm Radiator Windows 8 64-bit 34" LG 34UC87C-B 21:9 IPS LED Monitor 
MonitorKeyboardPowerCase
27" ASUS VG278H Filco Majestouch Tenkeyless Corsair AX750 Cooler Master HAF 932 
MouseMouse PadAudioAudio
Steelseries Sensei Steelseries 9HD Audio Technica ATH-AD700 Samson C01U Condenser Microphone 
  hide details  
Reply
post #3 of 4
14aren is the best I found in my couple hours I spent looking (about 6 months ago). But yeah, try that, it was awesome, just remember to press F2 to unlock the advanced features (it says this on the left, but it's easy to overlook the first time you open the program).

http://www.1-4a.com/cgi-bin/rename.cgi
JJS
(14 items)
 
  
CPUMotherboardGraphicsRAM
Xeon X5650 Asus P6X58D-e R9 290x 4Gb 24Gb HyperX DDR3 
Hard DriveHard DriveOSMonitor
250Gb 840 EVO 3x Seagate 3Tb Windows 7 x64 2x Dell U2711 
KeyboardPowerCaseMouse
Steelseries 7G, Das Professional S Silent, Antec 550W Not at the moment Logitech G9, G500 (x2), G500s 
Audio
Sound Blaster Z 
  hide details  
Reply
JJS
(14 items)
 
  
CPUMotherboardGraphicsRAM
Xeon X5650 Asus P6X58D-e R9 290x 4Gb 24Gb HyperX DDR3 
Hard DriveHard DriveOSMonitor
250Gb 840 EVO 3x Seagate 3Tb Windows 7 x64 2x Dell U2711 
KeyboardPowerCaseMouse
Steelseries 7G, Das Professional S Silent, Antec 550W Not at the moment Logitech G9, G500 (x2), G500s 
Audio
Sound Blaster Z 
  hide details  
Reply
post #4 of 4
Thread Starter 
Thanks for the replies. I managed to find one shortly after posting this (sorry I didn't reply immediately, been spending time in some html changing city names for about 138 different files in two locations).

http://www.joejoesoft.com/cms/showpage.php?cid=108

That seemed to work. Was able to export the cities into a txt from excel, then load it into this program. Unfortunately the documentation is meh, so I had to look around to figure out how to do it.

Had to clear the script of any fields inside it by clicking the erase tool at the bottom left of the window, on the right hand side of the script name. Then on the tab that says Textfile, import a text file. Scroll down a bit at the bottom and click the bubble that says Match Each Selected File To Each Line Of The Text File In Order.

Once I did that I had to go into "Script View", go to the Replace tab, check Replace Name With then had I had to put in ?text1? That seemed to do the trick.
Intel Computer
(13 items)
 
  
CPUMotherboardGraphicsRAM
[i5 2500k] [ASRock Z77 Extreme4-M] [EVGA GTX 560] [Kingston HyperX 8GB] 
Hard DriveOptical DriveOSMonitor
[Samsung F4 320gb] [Lite-On 24x Combo] [Windows 7 Ultimate 64bit] [Samsung SyncMaster 941bw] 
KeyboardPowerCaseMouse
[Microsft ANB-00001] [SeaSonic 520w M12II] [ASRock Z77 Extreme4-M Box] [Logitech G700] 
Mouse Pad
[Walmart Brand - Cloth Black] 
  hide details  
Reply
Intel Computer
(13 items)
 
  
CPUMotherboardGraphicsRAM
[i5 2500k] [ASRock Z77 Extreme4-M] [EVGA GTX 560] [Kingston HyperX 8GB] 
Hard DriveOptical DriveOSMonitor
[Samsung F4 320gb] [Lite-On 24x Combo] [Windows 7 Ultimate 64bit] [Samsung SyncMaster 941bw] 
KeyboardPowerCaseMouse
[Microsft ANB-00001] [SeaSonic 520w M12II] [ASRock Z77 Extreme4-M Box] [Logitech G700] 
Mouse Pad
[Walmart Brand - Cloth Black] 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Batch Rename Program?