Find Multiple Values in an imported CSV Table Using Multiple Search Criteria

PowerShell Help
1

Here is a sample of my CSV table:

Roadway_Width,Girder_Size,Skew,Min_Length,Max_Length,Standard

24,Concrete I-Beam (TX28),0,40,75,SIG-24
24,Concrete I-Beam (TX28),15,40,75,SIG-24-15
24,Concrete I-Beam (TX28),30,40,75,SIG-24-30
24,Concrete I-Beam (TX28),45,40,75,SIG-24-45
24,Concrete I-Beam (TX34),0,40,85,SIG-24
24,Concrete I-Beam (TX34),15,40,85,SIG-24-15
24,Concrete I-Beam (TX34),30,40,85,SIG-24-30
24,Concrete I-Beam (TX34),45,40,85,SIG-24-45
28,Concrete I-Beam (TX28),0,40,70,SIG-28
28,Concrete I-Beam (TX28),15,40,70,SIG-28-15
28,Concrete I-Beam (TX28),30,40,70,SIG-28-30
28,Concrete I-Beam (TX28),45,40,70,SIG-28-45
28,Concrete I-Beam (TX34),0,40,85,SIG-28
28,Concrete I-Beam (TX34),15,40,85,SIG-28-15
28,Concrete I-Beam (TX34),30,40,85,SIG-28-30
28,Concrete I-Beam (TX34),45,40,85,SIG-28-45

I would like to get user input data for Roadway_Width, Skew, and Length. Roadway_Width and Skew will be equal to the values in the table, but Length >= Min_Length and Length <= Max_Length. Return all of the values under Girder_Size and Standard that meet these criteria into 2 separate columns as below.

Girder_Size                                       Standard
--------------                                    -------------
Concrete I-Beam (TX34)                            SIG-28-45

Thank you very much in advance as I have been racking my brain over this and I am getting a headache.

2

Here is my code. It only outputs the same two values or no values at all.

[pre]

do{

$Roadway_Width = @()
$Girder_Size = @()
$Skew = @()
$Min_Length = @()
$Max_Length = @()
$Standard = @()

Write-Host ‘’

Import-Csv ‘T:\WFSDESGN\BRINSAP\List & Templates\Bridge Beam Lookups\Beam Span Length Lookup.csv’ |`
ForEach-Object {
$Roadway_Width += $.Roadway_Width
$Girder_Size += $.Girder_Size
$Skew += $.Skew
$Min_Length += $.Min_Length
$Max_Length += $.Max_Length
$Standard += $.Standard
}

$inputRoadway_Width = Read-Host -Prompt ‘Roadway Width’
$inputSkew = Read-Host -Prompt ‘Bridge Skew’
$inputLength = Read-Host -Prompt ‘Bridge Span Length’

Write-Host ‘’

if ($Roadway_Width -eq $inputRoadway_Width -and $Skew -eq $inputSkew -and $Min_Length -le $inputLength -and $Max_Length -ge $inputLength)
{
$Where = [array]::IndexOf($Roadway_Width, $Skew)
Write-Host -ForegroundColor Green "Beam Type: " $Girder_Size[$Where]
Write-Host -ForegroundColor Cyan "Standard: " $Standard[$Where]
}

Write-Host ‘’

$Response = Read-Host ‘Would you like to re-run? Type Y or N’

}
while($Response -eq “Y”)[/pre]

3

You’re actually not asking any question … you’re telling what you would like to do. :wink: This is not a script request forum. If you like to use structured data (tables, CSV files) you should read about cmdlets like Import-CSV and Foreach-Object. Please read the complete help including the examples to learn how to use it.

4

Thanks for your help.

5

I’m not sure if I really got what you’re trying to do but this might be helpful:

$CSVFile = ‘T:\WFSDESGN\BRINSAP\List & Templates\Bridge Beam Lookups\Beam Span Length Lookup.csv’

$Data = Import-Csv -Path $CSVFile |

Select-Object Girder_Size, Standard,

@{Name = ‘Roadway_Width’; Expression = { [INT]$.Roadway_Width } },

@{Name = ‘Skew’; Expression = { [INT]$.Skew } },

@{Name = ‘Min_Length’; Expression = { [INT]$.Min_Length } },

@{Name = ‘Max_Length’; Expression = { [INT]$.Max_Length } }


$inputRoadway_Width = Read-Host -Prompt ‘Roadway Width’

$inputSkew = Read-Host -Prompt ‘Bridge Skew’

$inputLength = Read-Host -Prompt ‘Bridge Span Length’


$Data |

Where-Object {

$.Roadway_Width -eq [INT]$inputRoadway_Width -and

$.Skew -eq [INT]$inputSkew -and

$.Min_Length -le [INT]$inputLength -and

$.Max_Length -ge [INT]$inputLength

} |

Format-Table -AutoSize

6

This was exactly what I needed. Thank you. Do you know why my code was only returning the same two options? I feel like it had something to do with my “IndexOf” statement.

7

To be really honest - No. I’m far away from beeing an expert in .Net-code or Powershell internals and I gave up thinking about code I don’t understand. :wink: