Solved

Remove last few characters of a folder name

Posted on 2013-02-07
12
1,185 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 6
12 Comments
 
LVL 56

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
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 56

Accepted Solution

by:
Bill Prew earned 400 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 56

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 56

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 56

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 56

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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
AutoHotkey is an excellent, free, open source programming/scripting language for Windows. It started out as a keyboard/mouse macros product, but has expanded into a robust language. This article provides an introduction to it, with links to addition…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

628 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