FFAStrans forum

Code: Select all

IncludePattern,ExcludePattern,OutputPath
*ASI*,,Z:\ASI\2020
*AOC*,,Z:\MAGAZINE NAME

Code: Select all

$debug = 0 # set to 1 in order to see logdebug messages
$filename = $args[0]
$csvfile = $args[1]
$Outputpath="" # outputpath remains empty unless filename matches the include pattern but does not match exclude pattern

function logdebug($linenum,$what){
#in production we must print the outputpath only, so debug can just be enabled for testing on commandline
    if ($debug){
        Write-Host("csv line $linenum $what")
        
    }
}

$linenumber = 2;
Import-Csv $csvfile | ForEach-Object {
   
    $includeArray = $_.IncludePattern.Split("|")#IncludePattern is a headline in the csv, as well as ExcludePattern and OutputPath
    
    #iterate include patterns
    foreach ($e_ptrn in $includeArray){
        if ($e_ptrn.Trim() -eq ""){
            logdebug $linenumber,"Include Pattern was empty"
            continue
        }
        if ($filename -like $e_ptrn.Trim()){
            logdebug $linenumber,"Filename matches include pattern $pattern"
            $Outputpath = $_.OutputPath
        }
    }

    $excludeArray = $_.ExcludePattern.Split("|")
    #iterate exclude patterns
    foreach ($e_ptrn in $excludeArray){
        if ($e_ptrn.Trim() -eq ""){
            logdebug($linenumber,"Exclude pattern was empty")
            continue
        }
        if ($filename -like $e_ptrn.Trim()){
            $Outputpath = "excluded"
            logdebug($linenumber,"Excluding File because it matches exclude pattern $e_ptrn")
        }
    }
    $linenumber =  $linenumber+1

}

Write-Host $Outputpath #finally write the found path to stdout. if nothing was found this will print just empty

Code: Select all

IncludePattern,ExcludePattern,OutputPath1,OutputPath2,OutputPath3,OutputPath4,OutputPath5,OutputPath6
*.*,foo,C:\temp\default
*3*|*4*,,C:\temp\3,c:\temp\4
*5* | *6*,,C:\temp\5,c:\temp\6

Code: Select all

$debug = 0 # set to 1 in order to see logdebug messages
$filename = $args[0]
$csvfile = $args[1]
$Outputpath = @() # outputpath remains empty unless filename matches the include pattern but does not match exclude pattern

function logdebug($linenum,$what){
#in production we must print the outputpath only, so debug can just be enabled for testing on commandline
    if ($debug){
        Write-Host("csv line $linenum $what")
        
    }
}

$linenumber = 2;
$havematch = 0
Import-Csv $csvfile | ForEach-Object {
   logdebug $linenumber,":"
    $includeArray = $_.IncludePattern.Split("|")#IncludePattern is a headline in the csv, as well as ExcludePattern and OutputPath
    
    #iterate include patterns
    foreach ($e_ptrn in $includeArray){
        if ($e_ptrn.Trim() -eq ""){
            logdebug $linenumber,"Include Pattern was empty"
            continue
        }
        if ($filename -like $e_ptrn.Trim()){
            if ($havematch -eq 1){
                #reset output path if another line already matched - ensure only last matching line defines output
                $Outputpath = @()
            }
            $havematch = 1 # make sure only the last matched line in the csv counts
            logdebug $linenumber,"Filename matches include pattern $pattern"
            $csvline = $_
            foreach ($property in $csvline.PSObject.Properties){
                if($property.Name -like 'OutputPath*'){
                    if ($property.Value){
                        if ($property.Value.Trim() -ne ""){ #only add if after removing whitespaces, it is not empty
                            $Outputpath += ($property.Value)
                        }
                    }
                }
            }
             
        }
    }

    $excludeArray = $_.ExcludePattern.Split("|")
    #iterate exclude patterns
    foreach ($e_ptrn in $excludeArray){
        if ($e_ptrn.Trim() -eq ""){
            logdebug($linenumber,"Exclude pattern was empty")
            continue
        }
        if ($filename -like $e_ptrn.Trim()){
            if ($havematch -eq 1){
                $Outputpath = @()
                $havematch = 0;
            }
            logdebug($linenumber,"Excluding File because it matches exclude pattern $e_ptrn")
        }
    }
    $linenumber =  $linenumber+1

}

if ($Outputpath.length -eq 1){
    $Outputpath[0] = $Outputpath[0] | ConvertTo-Json
    $Outputpath[0] = '[' + $Outputpath[0] + ']'
     Write-Host $Outputpath #finally write the found path to stdout. if nothing was found this will print just empty
}else{
    $outputjson = $Outputpath | ConvertTo-Json  -Compress  
    Write-Host $outputjson #finally write the found path to stdout. if nothing was found this will print just empty
}