Windows 10: Renaming multiple files using the command prompt Removing alphabet

Hi, I have the issue of renaming the multiple file by using CMD command. I would like to remove the alphabet or any text value or specific value of these file name and remain only the numeric number. For example Current name Preferred nameBruce Wayne 12345.pdf ---> 12345.pdfMan-bat 30049.pdf ---> 30049.pdfBatman2023.xls ---> 2023.xls Robin5002andbatman.png ---> *** Email address is removed for privacy ***

:)

 

renaming multiple files using the command prompt

Hi

Welcome to Microsoft community.

It looks like you're on the right track, but the command you're using isn't preserving the unique alphanumeric sequences in each file name. The 'ren' command in Windows doesn't support wildcards in the replacement text, which is why the unique sequences are being removed.

Instead, you can use a 'for' loop with the 'ren' command to rename each file individually while preserving the unique sequences. Here's how you can do it:

This command works as follows:

• for %A in (WI*.*) do This part of the command loops through each file in the current directory that starts with 'WI' and has any extension.
  
• ren "%A" "Windsor%~nxA" This part of the command renames each file, replacing 'WI' with 'Windsor' and preserving the rest of the original file name and extension.
  
• %~nxA This is a special variable that represents the name and extension of the current file in the loop.
  

Please note that you should run this command in the directory where the files you want to rename are located. Also, please ensure to back up your files before running this command, as renaming operations can't be undone.

Please feel free to let me know if you have any further updates, thanks.

Best regards

Derrick Qian | Microsoft Community Support Specialist

 

command prompt will not open in safe mode with command prompt

Would I just follow the same steps within safe mode after hooking up to the other system?

 

renaming multiple files using the command prompt

Hi

Thanks for your reply.

I apologize for the confusion. The command provided was intended to append the word "Windsor" before the existing filename, not to replace "WI" with "Windsor". My apologies for misunderstanding your requirements.

To replace "WI" with "Windsor" in the filenames, you can use a batch script with the ren command. However, the ren command itself doesn't support direct string replacement. You'll need a more powerful scripting language, like PowerShell.

Here's how you can do it with PowerShell:

1. Open PowerShell by clicking the Start button, typing 'PowerShell' into the search box, and pressing Enter.
   
2. Navigate to the directory containing your files using the cd command. For example: cd C:\path\to\your\files
   
3. Run the following command:
   
   
4. This command gets all files starting with 'WI' and renames them by replacing 'WI' with 'Windsor'.
   
5. Please be careful when running these commands, and make sure you have a backup of your files, as renaming operations are not easily reversible.