Replace files based on extension using Split-Path

Question

Let me start out by saying I am a complete beginner when it comes to this stuff. I am trying to replace a bunch of missing files with a place holder. Problem is there are multiple file types each needing a different place holder file.

I am using powershell 7, and Split-Path -extension seems to work just fine. But I can't seem to an if statement to allow me to select the correct placeholder file.

Any help would be greatly appreciated.

# List of Files to be replaced
$CSVFile ="C:\FileList.csv"
# Header for file location column
$FileLocationHeaderInCSV ="FileLocation"
#PlaceHolderFile Location
$PlaceHolderJPG ="C:\MissingFile.jpg"
$PlaceHolderTIF ="C:\MissingFile.tif"


Import-Csv $CSVFile | ForEach-Object {

    #CSV File Header Row
    $FileLocation = $_.$($FileLocationHeaderInCSV)

    $DestinationFolder= (Split-Path -Path $FileLocation)
   
    #Test if the folder exists, if it doesn't create it!
    if (!(Test-Path -path $DestinationFolder)) {
    
    New-Item $DestinationFolder -Type Directory
    
    Write-Host "Creating Folder '$DestinationFolder'" -ForegroundColor Green
    }

    else {
    
         }
    
    $FileExtension =(Split-Path -Extension $FileLocation)

    if ($FileExtension -eq ".JPG") {
        $PlaceHolderFile= $PlaceHolderJPG
        }
    elseif ($FileExtension -eq ".TIF") {
        $PlaceHolderFile= $PlaceHolderTIF
        }
        
    elseif ($FileExtension -eq ".TIFF") {
        $PlaceHolderFile= $PlaceHolderTIF
        }
        
    elseif ($FileExtension -eq ".IMG") {
        $PlaceHolderFile= $PlaceHolderTIF
        }
        
    else {
        Write-Host "Unknown File Type!!!!" -ForegroundColor Red
        }           
   

    Write-host "Replacing File '$FileLocation'" -ForegroundColor Cyan
    Copy-Item $PlaceHolderFile -Destination $FileLocation 

}

You haven't explained at all what you are trying to do. Please edit your post detailing what you are trying to accomplish. — Doug Maurer, Oct 05 '20 at 15:23

marsze · Accepted Answer · 2020-10-05T15:43:42.840

1

This would be a perfect use case for a switch statement:

$PlaceHolderFile = switch (Split-Path $FileLocation -Extension) {
    ".JPG" { $PlaceHolderJPG }
    ".TIF" { $PlaceHolderTIF }
    ".TIFF" { $PlaceHolderTIF }
    ".IMG" { $PlaceHolderTIF }
    default { throw "Unknown file type: $_" }
}

switch also has some advanced capabilities, e.g. you could use -Regex:

$PlaceHolderFile = switch -Regex (Split-Path $FileLocation -Extension) {
    '^\.JPG$' { $PlaceHolderJPG }
    '^\.(TIFF?|IMG)$' { $PlaceHolderTIF }
    default { throw "Unknown file type: $_" }
}

edited Oct 05 '20 at 15:43

answered Oct 05 '20 at 15:31

marsze

15,079
5
45
61

Thank you this did help clean up the code. I also found out the data in my CSV file was causing issue since it came in from SQL and had trailing spaces. – Rocky R Oct 05 '20 at 17:10

score 0 · Answer 2 · answered Oct 05 '20 at 16:04

0

Another short one-liner way:

$ext=Split-Path $FileLocation -Extension;if($ext -eq ".JPG"){$PlaceHolderJPG};if($ext-match"\.(TIF|TIFF|IMG)$"){$PlaceHolderTIF}

answered Oct 05 '20 at 16:04

Wasif

14,755
3
14
34

@marsze ok but still in one line your solution is better .. – Wasif Oct 05 '20 at 16:47

Replace files based on extension using Split-Path

2 Answers2