Remove numbers from middle of filename

Question

I have 400 tif files with names similar to:

that I need to have an underscore and 6 random numbers removed to look like:

I have searched and the only solutions I have found involve downloading software which my company does not permit.

Is there a way to use a batch file to remove those seven characters from these files?

I somehow doubt that this question is about DOS (as in Disk Operating System). Neither the Windows Command Prompt nor PowerShell have anything to do with that. — Ansgar Wiechers, Oct 18 '16 at 17:57
DOS and Command Prompt are often used interchangeably. I think most folks realize what's being talked about. — Nasir, Oct 18 '16 at 17:58
Ansgar sorry for the lack of proper vocabulary about DOS. I did mean the Command Prompt. As for the duplicate, that post did not answer my question because it searched for the same character in each file, and my files had 6 random numbers in each file bracketed by underscores. — Thomas Ward, Oct 18 '16 at 18:36

score 3 · Accepted Answer · answered Oct 18 '16 at 17:52

3

Since you are using the powershell tag, here a powershell solution:

Use the Get-ChildItem cmdlet to retrieve your files filtered by .tif and rename them using the Rename-Item cmdlet with a simple regex replace:

Get-ChildItem -Path c:\tmp -Filter '*.tif' | 
   Rename-Item -NewName { $_.Name -replace '_\d+' }

answered Oct 18 '16 at 17:52

Martin Brandl

Thank you Martin. Your code worked perfectly and solved my problem. I do not understand what _\d+ means. Any chance you could explain that? – Thomas Ward Oct 18 '16 at 18:32
gci -Path c:\temp -File -Filter "*.tif" | foreach{$arr=$_.name -split "_"; Rename-Item $_.FullName ($_.DirectoryName + "\" + $arr[0] + "_" + $arr[2]) } – Esperento57 Oct 18 '16 at 18:33
2

@ThomasWard `_\d+` is a regular expression matching "*an underscore, followed by one or more digits*". See [here](https://regex101.com/r/5LQIVY/1) how it matches against your filenames. – TessellatingHeckler Oct 18 '16 at 18:39

1 Answers1