Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Remove last few characters of a folder name

Posted on 2013-02-07
12
Medium Priority
?
1,349 Views
Last Modified: 2013-02-18
I found this script on this website to remove the last few characters of a file name but I was wondering if the same could be done for a folder name:

@echo off
setlocal enabledelayedexpansion
 
for %%F in (*.docx) do (
  set fn=%%~nF
  ren  "%%F"  "!fn:~0,-4!%%~xF"
)

Can it be changed to check a folder and rename all the sub folders by removing the last 7 characters?

Thank you.
0
Comment
Question by:cbones
  • 6
  • 6
12 Comments
 
LVL 59

Expert Comment

by:Bill Prew
ID: 38865569
Yes, this would do what you wanted.  Typically folders don't have extensions, if that isn't trrue in your case let me know and we can adjust.  Change the folder name in the PUSHD to match the root folder you want to search for subfolders in.

@echo off
setlocal enabledelayedexpansion

pushd "c:\temp"

for /D %%F in (*) do (
  set fn=%%~nF
  ren "%%~F" "!fn:~0,-4!
)

Open in new window

~bp
0
 

Author Comment

by:cbones
ID: 38866242
Thank you for your response.  I have folders with foldernames like below:

folder1_folder_12345678_1234567
folder2_folder_98765432_9876543
folder3_folder_12345321_8765348

When I run the script above it returns:

folder1_folder_1234
folder2_folder_9876
folder3_folder_8765

It seems to be erasing more than 7 characters.  Any ideas?

Thank you.
0
 

Author Comment

by:cbones
ID: 38866328
BP,

If I add 'echo' to the script it shows the rename of the folders correctly.  I can change the # 7, 8, 9 or 10 characters and it shows the rename correctly.  Once I remove the 'echo' it erases more than the # of characters.

@echo off
setlocal enabledelayedexpansion

pushd "c:\temp"

for /D %%F in (*) do (
  set fn=%%~nF
echo  ren "%%~F" "!fn:~0,-4!
)
0
How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

 
LVL 59

Accepted Solution

by:
Bill Prew earned 1600 total points
ID: 38866609
Looks like I lost a double quote along the way, try changing:

echo  ren "%%~F" "!fn:~0,-4!

to

echo  ren "%%~F" "!fn:~0,-4!"

~bp
0
 

Author Comment

by:cbones
ID: 38867596
BP,

I tried that and when I use echo it returns the correct folder name.  Once I take the echo out, I receive this message "a duplicate file name exists, or the file cannot be found".  Right after that almost the whole file name gets erased.  

Thank you.
0
 
LVL 59

Expert Comment

by:Bill Prew
ID: 38868310
Wht is the file name causing a problem, does it have any special characters in it (non alphabetic)?

~bp
0
 

Author Comment

by:cbones
ID: 38868369
All the folders have underscores in them and commas.

Folder1_test_20130208_1234567
Folder2_test_20130208_1234987
Folder3_folder_02130208_9876543
Test,test1_02130208_1234876

Can be named like that. Different names, all have the date in them.
0
 
LVL 59

Expert Comment

by:Bill Prew
ID: 38869880
Odd, I ran the test here, and it worked as expected.  See the logging below.

C:\ee\EE28024090>dir
 Volume in drive C is System
 Volume Serial Number is 0000-0000

 Directory of C:\ee\EE28024090

02/08/2013  05:08 PM    <DIR>          .
02/08/2013  05:08 PM    <DIR>          ..
02/08/2013  05:06 PM               417 EE28024090.bat
02/08/2013  05:06 PM    <DIR>          folder1_folder_12345678_1234567
02/08/2013  05:06 PM    <DIR>          Folder1_test_20130208_1234567
02/08/2013  05:06 PM    <DIR>          folder2_folder_98765432_9876543
02/08/2013  05:06 PM    <DIR>          Folder2_test_20130208_1234987
02/08/2013  05:06 PM    <DIR>          Folder3_folder_02130208_9876543
02/08/2013  05:06 PM    <DIR>          folder3_folder_12345321_8765348
02/08/2013  05:06 PM    <DIR>          Test,test1_02130208_1234876
               1 File(s)            417 bytes
               9 Dir(s)             999 bytes free

C:\ee\EE28024090>EE28024090.bat

C:\ee\EE28024090>dir
 Volume in drive C is System
 Volume Serial Number is 0000-0000

 Directory of C:\ee\EE28024090

02/08/2013  05:09 PM    <DIR>          .
02/08/2013  05:09 PM    <DIR>          ..
02/08/2013  05:09 PM               417 EE28024090.bat
02/08/2013  05:06 PM    <DIR>          folder1_folder_12345678_123
02/08/2013  05:06 PM    <DIR>          Folder1_test_20130208_123
02/08/2013  05:06 PM    <DIR>          folder2_folder_98765432_987
02/08/2013  05:06 PM    <DIR>          Folder2_test_20130208_123
02/08/2013  05:06 PM    <DIR>          Folder3_folder_02130208_987
02/08/2013  05:06 PM    <DIR>          folder3_folder_12345321_876
02/08/2013  05:06 PM    <DIR>          Test,test1_02130208_123
               1 File(s)            417 bytes
               9 Dir(s)             999 bytes free

Open in new window

~bp
0
 

Author Comment

by:cbones
ID: 38873089
BP,

Thank you.  Sorry, yes it is working correctly.  What I didn't notice is that there can be folders like below:

FOLDER_FOLDER1_20130210_1234567
FOLDER_FOLDER1_20130210_9876543

When the script runs it does what it is suppose to and removed the last 7 characters and prompts that there is a duplicate name because once the last 7 are removed those folders would be identical.

I am not sure how to handle that.

Thank you
0
 
LVL 59

Expert Comment

by:Bill Prew
ID: 38874089
If you can come up with the logic that you want when a duplicate occurs we can try to add that to the script.  Should really have it in there since dupes can occur.  Would you want to add something to the end?  Or just flag as a problem? Etc.

~bp
0
 

Author Comment

by:cbones
ID: 38874131
What if there were duplicates could you leave 1 character, delete 6 instead of 7 characters. Or add a number 1 to it?  

Would that be difficult?

Anything would work.
0
 
LVL 59

Expert Comment

by:Bill Prew
ID: 38901960
What if there were duplicates could you leave 1 character, delete 6 instead of 7 characters. Or add a number 1 to it?  

Would that be difficult?

Anything would work.
I see you closed this question (thanks for the feedback).  If you still want help with the duplicate problem, post as another question, link it to this one, and I'll work something up.

~bp
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
This article was inspired by a question here at Experts Exchange (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28629170.html). The requirements stated in that question are (1) reduce the file size of a large number of…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question