Windows 10 How to copy files into corresponding folders?

q988988

New Member
Joined
Nov 21, 2019
Messages
19
I have a list of csv files that have to be copy into a list of folders with same names. Rather than manually cutting each one into the corresponding folder, is there a trick of doing this in windows?
 
Last edited by a moderator:
Solution
Yeah a script would be the most efficient especially if you have a large number of files. In powershell it would be like this
Code: 
$CopyFromPath = "C:\Some\Path"
$CopyToRootDirectory = "C:\Some\Other\Path"
$FileTypeFilter = "*.xlsx"

$Files = Get-ChildItem -Path $CopyFromPath -Filter $FileTypeFilter

foreach($File in $Files)
{
    $DirectoryName = "\$File.BaseName"
    $CopyToDirectory = "$CopyToRootDirectory$DirectoryName"

    if(-not(Test-Path $CopyToDirectory))
    {
        New-Item -Path $CopyToDirectory -ItemType Directory
    }
    Move-Item $File.FullName -Destination $CopyToDirectory -Forc
}

or it could be created as a function so that you can pass it different values for reuse
Code: 
Function Move-ItemToDirectory
{
    param...
Sort by date Sort by votes
How about the file names? I just did a test... the code worked fine with the file names A,B,C but not for a bit more complex names. And the code also worked fine for the folders with existing non-xlsx files. SO the only issue left would be the file names. Is it possible to make some tweaks on the code so it works for the file name such as 22B_1 or 100_2?
 
Upvote 0 Downvote
This is weird...because all the files with simple names got moved over except the one shown in the screenshot...
 
Upvote 0 Downvote
Maybe there is a limitation in the code by default that only allows for the file name to have a certain number of character?
 
Upvote 0 Downvote
I tested a couple of more times...it just did not work the a more complicated file name rather than A,B,C... anyone can help out?
 
Upvote 0 Downvote
You must log in or register to reply here.

Similar threads

M
  • Solved
Create MSI to copy files
Replies
11
Views
478
ChatGPT
  • Article Article
Agents in OneDrive: Turn Your Files into Copilot AI Assistants
Replies
1
Views
49
ChatGPT
  • Article Article
Why File Explorer Pauses at Calculating and How to Speed Copy Tasks
Replies
0
Views
36
ChatGPT
  • Article Article
Copilot in Excel Now Imports Data From Web and Office Files Into Spreadsheets
Replies
0
Views
44
ChatGPT
  • Article Article
How to Undo OneDrive Backup in Windows 11 and Move Folders Back Local
Replies
1
Views
95
ChatGPT