Exclude list of directories from Get-ChildItem based on a CSV file

Question

The directory structure is as follows:

    Directory: \\L04274\C$\Temp


Mode                LastWriteTime         Length Name                                            
----                -------------         ------ ----                                            
d-----        3/12/2018   2:04 PM                AutomatedImportProcess                          
d-----        3/13/2018  11:34 AM                f1                                              
d-----        3/13/2018  11:33 AM                f2

the exclusion CSV file contains one column (later might be extended to two columns which includes file types as well).

ExcludeDirectory
\\L04274\C$\Temp\f2\
\\L04274\C$\Temp\f1\

The PowerShell command looks like this but it does not seem to be doing what is expected:

$path = '\\L04274\C$\Temp\f1' 
$exclusion = @(Get-Content -LiteralPath '\\L04274\C$\Temp\Exclusions.csv')

Get-ChildItem -Path $path -Force -Exclude $exclusion

What I expect to see is only the following folder:

\\L04274\C$\Temp\AutomatedImportProcess\

Take a look at this question: stackoverflow.com/questions/15294836/… — henrycarteruk
– henrycarteruk, Commented Mar 13, 2018 at 17:15
@JamesC. this is not quite what I want to do. in the question you mentioned they are using the following to exclude: [$archive = archive,Archive,ARCHIVE] where I want to read from a csv into an array or some list and use that list to exclude folders/files. So if I want to exclude the f1 folder then the entry "\\L04274\C$\Temp\f1\" should be used to exclude. and if I want to only exclude the text files then "\\L04274KAMRANF\C$\Temp\f1*.txt" should be used. — Fuzzy
– Fuzzy, Commented Mar 13, 2018 at 17:29
The first thing that I notice is that you do your Get-ChildItem at '\\L04274\C$\Temp\f1' but your exclusions have C:\Temp as their root. — EBGreen
– EBGreen, Commented Mar 13, 2018 at 17:47

Mathias R. Jessen · Accepted Answer · 2018-03-13 18:18:57Z

2

Exclude only works against file names.

You'll have to use a nested Where-Object statement after the fact:

$path = '\\L04274\C$\Temp\f1' 
$exclusions = @(Import-Csv -LiteralPath '\\L04274\C$\Temp\Exclusions.csv') |Select-Object -Expand ExcludeDirectory

Get-ChildItem -Path $path -Force |Where-Object {
    $FullName = $_.FullName
    -not($exclusions|Where-Object {
        $FullName -like "$_*"
    })
}

If the full path doesn't match any of the exclusions, the -not(...) statement will return $true, otherwise the file will be omitted

edited Mar 13, 2018 at 18:18

answered Mar 13, 2018 at 17:47

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Fuzzy Over a year ago

Thanks this threw an exception but it did give me an idea that led me to solve the issue:

Fuzzy Over a year ago

FYI exception was as follows: Select-Object : Property "ExcludeDirectory" cannot be found. At C:\Users\kamranf\Documents\PoweShellScripts\Untitled15.ps1:2 char:85 + ... RANF\C$\Temp\Exclusions.csv') |Select-Object -Expand ExcludeDirectory + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : InvalidArgument: (ExcludeDirectory:PSObject) [Select -Object], PSArgumentException + FullyQualifiedErrorId : ExpandPropertyNotFound,Microsoft.PowerShell.Commands .SelectObjectCommand

Mathias R. Jessen Over a year ago

@KamranFarzami My mistake, should have been Import-Csv rather than Get-Content

Fuzzy · Accepted Answer · 2018-03-13 18:16:00Z

0

This worked:

$path = '\\L04274\C$\Temp' 
$exclusion = @(Get-Content -LiteralPath '\\L04274\C$\Temp\Exclusions.csv')

 (Get-ChildItem -Path $path -Force -Exclude $exclusion | ForEach-Object -Process { 
  $allowed = $true 
  foreach ($exclude in $exclusion) { 
     if ( $_.FullName  -like $exclude) {  
       $allowed = $false
       break
    }

  }
  if ($allowed) {
    $_ 
  }
 }).FullName

answered Mar 13, 2018 at 18:16

Fuzzy

3,8102 gold badges17 silver badges34 bronze badges

1 Comment

Bacon Bits Over a year ago

Note that "\\L04274\C$\Temp\f2\file.txt" -like "\\L04274\C$\Temp\f2\" is false. You'd need it to be "\\L04274\C$\Temp\f2\file.txt" -like "\\L04274\C$\Temp\f2\*" to be true. Not sure what you're after, however.

Collectives™ on Stack Overflow

Exclude list of directories from Get-ChildItem based on a CSV file

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related