That works but to a point. I did all that you suggested, but then what happened was that there's 116 pictures in my folder, and when it got to the 26th picture, it started adding the number in parenthesis starting with (1) again?????
If you're using Windows 11, instead of using '/d' in the command, use '/b'. For example: dir /b > list.txt Microsoft changed the way dir commands function in Windows 11 and you now have to use the /b tag to generate a list that's easy to paste into Excel. Using /d will end up with a wrapped list with two filenames per row instead of one, which makes pasting into Excel a CHORE to the point where it'd be more time-efficient to just manually go through each file and rename them yourself in file explorer. If you use /b, it will generate a list formatted the same way as the list that's used in this video.
Great way, I have another method to change all my movie name series according to their original name at once using cmd or .cmd text file, you can modified the code to do as you need @echo off setlocal enabledelayedexpansion REM Modify the following line with the desired folder path where your files are located set "folderPath=___________________________" REM Modify the following line with the keyword that indicates the episode number in your file names set "keyword=_____________" for %%A in ("%folderPath%\*.*") do ( set "filename=%%~nxA" set "episode=" for /F "delims=" %%B in ("!filename!") do ( set "temp=%%B" set "temp=!temp:*%keyword%=!" if "!temp!" neq "!filename!" ( set "episode=!temp!" REM Remove any non-digit characters from the episode number set "episode=!episode:~0,2!" REM Extract the first two characters of the episode number REM Check if the episode number is a single digit and doesn't start with a zero if "!episode:~1,1!" equ "-" set "episode=0!episode:~0,1!" REM Modify the following line to define the desired naming method for the renamed files set "newname=___________!episode!" rem Remove any non-digit characters from the file extension set "extension=%%~xA" set "extension=!extension:~1!" rem Combine the new name, episode number, and file extension set "newname=!newname!.!extension!" rem Remove the hyphen "-" from the new name set "newname=!newname:-=!" ren "%%~A" "!newname!" ) ) ) echo All files renamed successfully.
thanks i only had to rename 10 files to remove "01 - ", "02 - ", "03 - " (and so on) from the beginning of the filename and it was way easier to just press F2, LEFT, DEL x5, ENTER, DOWN, repeat x10. preciate it
thanks but i had a problem, I am able to rename only 50% files, please help me to resolve this problem. i need another help, may i take all data from different sheets (more than 500 sheets) in one sheet only in excel
Yes you can get as there is a option in Excel to get data from the folder... You have to just put all (500 Excel) into that folder... If you want we can make a separate video on the same.
Absolutely very FEW will be able to follow all that messy instructions. Firstly one needs Microsoft Office. Two, Going back and forth and trying to remember all the steps will either take a genius or a complete idiot. <chuckle>...Can't it be done in Windows with a few DOS command syntax like Mary*.* to Anna*.* or something? (probably wrong syntax but one should understand better.
amazing, very useful.....only one problem i have faced is in the video you said to type "dir/d=>filename.txt" it creates file but in that, file names have no order or not came one by one, it came infront of each other..... so i tried /b insted of /d and i got proper results. (i did it blindly) can you pls explain what is reason behind that??
I used this to remove the "(2) - Copy" from all files after separating the originals to a different folder. Excel was perfect for this becasue the formula makes it much easier for different file types too. Pro Tip: I had to do this in a Network folder I could not cd into. In that case, add a column for filepath to go in the equation and it will work the same if you have write access. Example: a new column for filepath = 'V:\user\home enamedFiles\' I placed this in the E column then equation becomes: =D2&" """&E2&A2&""" """&C2&B2&""""
Thank you so much you really helped me. But.. in a different way :D I was using other easier tutorial from a to z but it didn't work. So I changed only last step from that other tutorial and I have added quotes (") to the files name. And it worked like magic. Thank you so much ❤️