script copy files from a folder to other folder - filename condition

All replies

• 

  

  1

  Sign in to vote

  Please read the following first:

  • Posting guidelines
  • Handy tips for posting to this forum
  • How to ask questions in a technical forum
  • Rubber duck problem solving
  • How to write a bad forum post
  • Help Vampires: A Spotter's Guide

  ---

  -- Bill Stewart [Bill_Stewart]

  • Proposed as answer by Bill_Stewart Thursday, August 20, 2015 9:14 PM
  • Marked as answer by Bill_Stewart Wednesday, September 9, 2015 7:43 PM

  Friday, July 31, 2015 9:05 PM
• 

  

  0

  Sign in to vote

  $Path = 'C:\folder_A'
  Get-ChildItem -Path $Path -Filter 'results*.xls' | 
      Group-Object {$_.Name.Substring(7,6)} | ForEach-Object {
          $NewFolder = New-Item -Name $_.Name -Path $Path -ItemType Directory
          $_.Group | Copy-Item -Destination $NewFolder
      }

  or

  Get-ChildItem C:\folder_A -File | ForEach-Object {
      $dest = '{0}\{1}\{2}' -f $_.Directory, $_.Name.Substring(7,6), $_.Name
      New-Item -Path $(Split-Path $dest -Parent) -ItemType Directory -Force
      Copy-Item -Path $_.FullName -Destination $dest
  }

  
  

  • Edited by Leif-Arne Helland Friday, July 31, 2015 10:33 PM

  Friday, July 31, 2015 9:51 PM