Powershell script for looking through CSV using regular expression and outputting matching string. Can be used in Content Hub target job export to analyze imageMagick failures

MatchFilenamesInCsv.ps1

$csvFile = Get-Item "C:\path-to-csv-file.csv"
$stateDescriptions = Import-Csv $csvFile -Delimiter ';' | Select-Object Target.StateDescription
$result1 = @()

foreach($desc in $stateDescriptions)
{
    # searching for filename with extension here (example pattern match /123testfile.tif:)
    $desc -match "\/(?<filename>[^\/]*\.\w+):" #"\/\d{6}_.+\.[a-z0-9]+:"
    if($Matches.Count -gt 0)
    {
        Write-Host $Matches.filename
        $result1 += [PSCustomObject]@{
            Name = $Matches.filename
        }
    }

}

$result1 | Select-Object Name -Unique | Export-Csv -NoTypeInformation -Path .\FileNames.csv -Delimiter ';'