$list = "SCP_EG2102_15", "SCP_EG2102_12_A11", "SCP_EG2102_13_A21", "SCP_EG2102_10_B11", "SCP_EG2102_11_B21", "SCP_EG2102_08_C11", "SCP_EG2102_09_C21", "SCP_EG2102_06_D11", "SCP_EG2102_07_D21", "SCP_EG2102_04_E11", "SCP_EG2102_05_E21", "SCP_EG2102_02_F11", "SCP_EG2102_03_F21", "SCP_EG2102_14_R11", "SCP_EG2102_01_R21" function Combine-Csv { param ( $sufix ) Write-Output "Writing FTOptix_Combined_$sufix.csv" Set-Content -Path "FTOptix_Combined_$sufix.csv" "Location,Site,PLCName,SymbolName" Get-Content "./FTOptix_Combined.csv" | where { $_ -match $sufix } | add-content -Path "FTOptix_Combined_$sufix.csv" } Write-Output "Writing to $($list.Count) files" $list | foreach { Combine-Csv -sufix $_ }