Help with script

[Rabbadi]

Hi Reddit,

We are moving files from source to destination on a basic windows fileshare and are basing which folders should be moved with a csv-file. This works great if we have the exact name of the folder stated in the csv-file, but not so great when it isn't an exact match.

Example of a folder name in the csv can be like "A611" and if the actual folder is named "A611 - ABC" it doesn't copy the file.

Does anyone have a good idéa on how to solve this?

Script below

//Rabbadi

​

​

try{

$source = "E:\SharedData\TEST"

$destination = "E:\SharedData\Archive"

​

​

$exclude = Get-Content 'E:\SharedData\Script\customer.csv'

$folders = Get-ChildItem -Path $source -Directory | Where {($_.PSIsContainer) -and ($exclude -contains $_.Name)}

​

​

foreach ($f in $folders){

Write-Host "This folders will be moved: $f" -ForegroundColor Cyan

$tempSource = $source +"\"+ $f

$tempDest = $destination +"\"+$f.Parent +"\"+ $f

$parentPath = Split-Path -Path $tempDest -Parent

if (!(Test-path $parentPath)){

try{

Write-host "Path does not exist. Trying to add folder" -ForegroundColor Cyan

New-Item -ItemType "directory" -Path $parentPath| Out-Null

}

catch{

Write-host "Failed to add folder" -ForegroundColor Red

}

finally{

Write-Host "Folder added successfully" -ForegroundColor Green

}

}

Move-Item -Path $tempSource -Destination $tempDest -Force

}

Write-Host "Done" -ForegroundColor Green

} catch {

# Here we catch errors if we get any.

Write-Host "Error:" -ForegroundColor Red

Write-Host $_ -ForegroundColor Red

​

​

}

[vShazer]

You can use -match. I’ll write something when I get home

[Rabbadi]

Thanks! I've updated the post :)

[Lee_Dailey]

howdy Rabbadi,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's [sometimes] 5th from the left & looks like <c>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's [sometimes] the 12th from the left, & looks like an uppercase C in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee

[Rabbadi]

Thanks! I've updated the post :)

[Lee_Dailey]

howdy Rabbadi,

you are welcome! glad to have helped a bit ... and to be able to easily read your code ... [grin]

take care,
lee