中国DOS联盟

Do you have UltraEdit installed?

First, copy the mixed directory files and attribute times in, and replace the space segments used to separate the contents with <tab> characters.

Then copy the content into Excel, and Excel will place the directory files and attribute times in different columns according to the <tab> delimiter.

Then add an empty column in front of the directory file column, insert xcopy, and replace the column after the directory file column with the target directory and /e.

After that, copy them all into a bat file together.

I'll try installing UltraEdit. Thanks for your attention

I followed the file you provided for testing and it works. I don't know why you can't.

Generated run.bat
copy "C:\Documents and Settings\All Users\「Start」Menu\Programs\Adobe ImageReady CS.lnk 1KB A 2007-6-20 19:19:52 " "D:\Documents and Settings\All Users\「Start」Menu\Programs\Adobe ImageReady CS.lnk 1KB A 2007-6-20 19:19:52 "
copy "C:\Documents and Settings\All Users\「Start」Menu\Programs\Adobe Photoshop CS.lnk 1KB A 2007-6-20 19:19:52 " "D:\Documents and Settings\All Users\「Start」Menu\Programs\Adobe Photoshop CS.lnk 1KB A 2007-6-20 19:19:52 "
copy "C:\Documents and Settings\All Users\「Start」Menu\Programs\Startup\Adobe Gamma Loader.lnk 2KB A 2007-6-20 19:19:52
.
.
.
..

I need to add quotes to the values in each cell in EXCEL. How can I add quotes to the values in a column?

Then add a column before and after the directory file list, add quotes in it, and then copy back to UltraEdit, use column mode to delete the excess <tab> symbols.

Well, I tried, but there are still some problems. When copying *.lnk, it prompts whether it's a file or a directory? You need to add \ after each directory.

It's okay to save the file as TXT using EXCEL, but there's still one problem. As follows:

xcopy /e "C:\Program Files\Common Files\InstallShield\Professional" "D:\Target Files\Program Files\Common Files\InstallShield\Professional"
xcopy /e "C:\Program Files\Common Files\InstallShield\Professional\RunTime" "D:\Target Files\Program Files\Common Files\InstallShield\Professional\RunTime"
xcopy /e "C:\Program Files\Common Files\InstallShield\Professional\RunTime\0701" "D:\Target Files\Program Files\Common Files\InstallShield\Professional\RunTime\0701"
xcopy /e "C:\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32" "D:\Target Files\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32"
xcopy /e "C:\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32\ctor.dll" "D:\Target Files\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32\ctor.dll"
xcopy /e "C:\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32\DotNetInstaller.exe" "D:\Target Files\Program Files\Common Files\InstallShield\Professional\RunTime\0701\Intel32\DotNetInstaller.exe"

When copying the first directory, it will copy all the files under the directory to the directory folder. When it's a directory, it's required to only create the directory, and when it's a file, it's only to copy the single file

There is a column in your file that shows attributes. When you first copy it into Excel, sort by attributes, pick out the D attribute and handle it separately from the file.

xcopy /t /e directory target
It won't copy the files.

Please upload your file as an attachment, and I'll test it.

I was occupied with other things the past two days, sorry. The original file is in the attachment.

for /f "usebackq delims== " %%i in (h:\cp.txt) do (mkdir e:\1"%%~pi")&(copy "%%i" e:\1"%%~pi")

There will still be redundant things upstairs. (mkdir "directory") & (copy "C:\"directory"\data1.cab 1,886KB A 2004-6-16 9:44:50" "directory")

RE beyoungse:

I tested again, the one on my 13th floor is okay, change yourfile.txt to your changfiles.txt file.

Thank you. I tested with XP XP2 and it works.

Last edited by beyoungse on 2007-7-9 at 10:28 PM ]