PowerShell Search and Combine CSV
<#
ScritpsByScott.com
.Synopsis
To quickly combine multiple CSV files and select only rows with specific text found
.DESCRIPTION
Takes input from folder and selects only CSV files.
Searches each row and selects only rows of data with select text in the row.
Exports the data to a CSV file that can be separated out with Text to Columns
.EXAMPLE
Run the script and place the folder path at prompt:
Example:
C:\Users\Scott\Downloads\Filter_CSV_Data\
>#
Try
{
# CSV files under the selected folder
$Path=Read-host "Enter Folder Path"
$Dir = get-childitem $Path -ErrorAction Stop
$List = $Dir | where { $_.extension -eq ".csv" } -ErrorAction Stop
Foreach ($File in $List.name)
{
$MyFile=Get-Content "$Path\$File" -ErrorAction Stop
#Loop through data to get only Item without the No response
Foreach ($Line in $MyFile)
{
$MyString = $Line.ToString()
#Conditional statement to filter out records required
If (($Mystring -match "Picked"))
{
#Output data to text file for import to Excel
$Line | out-file $Path\FullList.csv -Append -ErrorAction Stop
}
}
}
}
Catch
{
Write-Output $_.Exception
}
