Solved

Strip Files from Folders into Single Folder

Posted on 2008-06-15
5
445 Views
Last Modified: 2012-06-27
I am trying to find a XCOPY or ROBOCOPY solution to Strip Files from a Folder Structure into a Single Folder.

Here follows an example.

Source Structure:
C:\MYFOLDER\STRUCTURE\AFOLDER123\AFILE.XLS
C:\MYFOLDER\STRUCTURE\BFOLDER456\BFILE.XLS
C:\MYFOLDER\STRUCTURE\CFOLDER7\CFILE.XLS
C:\MYFOLDER\STRUCTURE\DFOLDER8\DFILE.XLS
C:\MYFOLDER\STRUCTURE\EFOLDER99999999\EFILE.XLS

Destination (with how I want my files):
E:\MYFOLDER\STRUCTURE\AFILE.XLS
E:\MYFOLDER\STRUCTURE\BFILE.XLS
E:\MYFOLDER\STRUCTURE\CFILE.XLS
E:\MYFOLDER\STRUCTURE\DFILE.XLS
E:\MYFOLDER\STRUCTURE\EFILE.XLS

The above requirement appeared so straight forward when I took it on, but I have not been able to find the right XCOPY or ROBOCOPY parameters to achieve this. I would expect the solution to be some way of using a wildcard foldername to translate C:\MYFOLDER\STRUCTURE\AFOLDER123\*.XLS to C:\MYFOLDER\<WILDCARD>\AFOLDER\*.XLS so I can achieve something like this:
XCOPY C:\MYFOLDER\STRUCTURE\*\*.XLS E:\MYFOLDER\STRUCTURE\
Unfortuntately you cannot use an asterisk to wildcard a foldername as above.

Please do not suggest using a recursive folder switch such as /S, because I can assure you that the following will not produce the required result:
XCOPY /S C:\MYFOLDER\STRUCTURE\  E:\MYFOLDER\STRUCTURE\
The structure from which we need to strip the files will be reproduced with the /S recursive switch.

Any assistance in this matter will be greatly appreciated.
0
Comment
Question by:andrejonker
[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
  • 4
5 Comments
 

Author Comment

by:andrejonker
ID: 21788116
Moment of clarity!!! I somehow just figured it out. Consider the following command line solution:

      c:
      cd c:\MYFOLDER\STRUCTURE\
      for /r %a in (*.xls) do xcopy "%a" e:\MYFOLDER\STRUCTURE\*.xls

If you can improve on the above, or point out a real show-stopper issue with using this as a solution, I will award the points. Else, this issue is considered resolved :-)
0
 
LVL 4

Accepted Solution

by:
zveljkovic earned 500 total points
ID: 21788125
I just wanted to post you a similar solution :)

FOR /R C:\MYFOLDER\STRUCTURE %%f IN (*) DO copy %%f E:\MYFOLDER\STRUCTURE
0
 

Author Closing Comment

by:andrejonker
ID: 31467318
Considering your timing - I will award you some points :-D
0
 

Author Comment

by:andrejonker
ID: 21807470
Big oops... I did not test zveljkovic's suggestion.

I get the following error:
%%f was unexpected at this time.

I changed to %%f to %a as follows:
for /r C:\MYFOLDER\STRUCTURE %a in (*.txt) do xcopy "%a" e:\MYFOLDER\STRUCTRE\*.txt

Note the quotes around the second %a as in "%a". This is to cater for long file/folder names with spaces.
0
 

Author Comment

by:andrejonker
ID: 21807857
The error again came up... This time when I put the above in a batch script... seems the %%f was correct after all. Seems the rule is:
 for CLI use one % and for CMD use two?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

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

This article describes how to set permissions to allow a limited-permissions user to start and stop a particular System Service.   It is always best to give users only the permissions that they need to perform their job, so tweaking particular permi…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …

705 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