10

I have a Windows Server 2003 server that has a whole bunch of filenames that need renaming. Basically, I just need all - (hyphens) replaced with _ (underscores), no matter where they are in the filename. Assume that there are no duplicates.

I can do this on my Mac with a little script but the files are too large and crazy to transfer to my Mac, rename, then go back to the server. Is it possible to do this in a Windows command prompt without having to download a renamer or any additional software?

Jens Erat
  • 18,485
  • 14
  • 68
  • 80

6 Answers6

14

From the command prompt - assuming that all of your files are in the same directory:

ONE-LINER

for /f "tokens=* delims= " %i in ('dir /b "*.txt"') do Set LIST=%i& set LIST | ren "%~fi" "%LIST:-=_%"

Keep in mind that this is a one shot per command prompt window. That means if you cancel this for any reason, then you'll need to open another command prompt and run again.

slhck
  • 235,242
3

Batch File to replace one character in a filename with another character

Consider using a free GUI app to hold your hand: http://www.bulkrenameutility.co.uk/Main_Intro.php

If you must this yourself with a batch file, be super careful! Batch scripts don't have an "undo" button. If you execute your bat script which applies to all files recursively under somewhere like C:, you've just renamed every file on your computer and it will immediately stop working and fail to boot. You'll have to do an full OS reinstall. Always have a backup!

First you'll have to decide do you want the batch file to work on a single file? To work on all files in a directory? Or do have it done recursively (all files/folders under a directory). Here are some pointers:

Batch file to replace all underscores _ with the letter M to all files in current directory

Put this in a batch file named change_underscores_in_this_directory.bat

@echo off
setlocal enabledelayedexpansion
for %%a in (*_*) do (
  set file=%%a
  ren "!file!" "!file:_=M!"
)

Execute it, and all the files in that directory with an underscore will be changed to an 'M'.

Use a Batch File to replace spaces with nothing (removing the spaces):

https://stackoverflow.com/questions/11270453/how-to-remove-spaces-from-file-names-in-bulk

Use a Batch File to replace spaces with underscores, Recursively:

https://stackoverflow.com/questions/1613644/how-to-replace-names-recursively-via-windows-batch-operation

Eric Leschinski
  • 7,393
  • 7
  • 51
  • 51
1

You can use the below Power shell script to achieve the desired result

# Set the path to the directory containing the files
$dirPath = "D:\COMLOGS\_traffic-files_\ZETTA-T1 - Copy\"

Get a list of all .txt files in the directory

$fileList = Get-ChildItem -Path $dirPath -Filter *.rp

Loop through each file and rename it

foreach ($file in $fileList) { $newName = $file.Name.Replace("_", "M") Rename-Item -Path $file.FullName -NewName $newName }

Destroy666
  • 12,350
1

Another solution would be to use two batch files.

File 1: run_rn.bat:

forfiles /m "*.log" /c " cmd /c rn @file"

File 2: rn.bat:

set LIST1=%1
set LIST2=%LIST1:_=;%
ren %LIST1% %LIST2%

The batch files have to be in the same directory like the files you want to change.

slhck
  • 235,242
Vlad
  • 11
1

Found it on stackoverflow:

https://stackoverflow.com/questions/261515/batch-file-script-to-remove-special-characters-from-filenames-windows

Set fso = CreateObject("Scripting.FileSystemObject")
Set re  = New RegExp

re.Pattern = "[-]" ' put all characters that you want to strip inside the brackets' re.IgnoreCase = True re.Global = True

If WScript.Arguments.Unnamed.Count = 1 Then If fso.FolderExists(WScript.Arguments.Unnamed(0)) Then Recurse fso.GetFolder(WScript.Arguments.Unnamed(0)) Else WScript.Echo "Folder not found." End If Else WScript.Echo "Please give folder name as argument 1." End If

Sub Recurse(f) For Each sf In f.SubFolders Recurse sf WScript.Echo sf.Name, " -> ", re.Replace(sf.Name, "") sf.Name = re.Replace(sf.Name, "") Next For Each sf In f.Files WScript.Echo sf.Name, " -> ", re.Replace(sf.Name, "_")

 If sf.Name <> re.Replace(sf.Name, "_" ) Then
   sf.Name = re.Replace(sf.Name, "_")
 End If

Next End Sub

phuclv
  • 30,396
  • 15
  • 136
  • 260
0

12noon has a FREE utility to do mass file renaming with full regular expression support, which is pretty cool. "Name Twister" info page with links to download

I haven't used this one in anger, but have used other apps of theirs (especially display changer) and been really happy.

Deltik
  • 19,971
AdamV
  • 6,396