Split csv file according to matching columns

Question

I have a file called test.csv, Data in the file is looking like this:

ServerName,Software
"server1.domain.com","Security Update for Windows Server 2003 (KB890046)"
"server1.domain.com","Security Update for Windows Server 2003 (KB893756)"
"server2.domain.com","Microsoft .NET Framework 3.5 SP1"
"server2.domain.com","Microsoft SQL Server 2005"
"server3.domain.com","Security Update for Windows Server 2003 (KB916281)"
"server3.domain.com","Security Update for Windows Server 2003 (KB917159)"

I want to split it into files for each server using "ServerName" as file name and containing the data from the "Software" column

I would like the output to look like this:

file: server1.domain.com.csv

Security Update for Windows Server 2003 (KB890046)
Security Update for Windows Server 2003 (KB893756)


file: server2.domain.com.csv

Microsoft .NET Framework 3.5 SP1
Microsoft SQL Server 2005"


file: server3.domain.com.csv

Security Update for Windows Server 2003 (KB916281)
Security Update for Windows Server 2003 (KB917159)

I'm new to Powershell and can't work out how to do it. Thanks.

Shay Levy · Accepted Answer · 2011-12-07 12:50:09Z

3

Try this, group the content by ServerName. Foreach group select the Software property and export it to a csv file with a name of each server:

Import-Csv test.csv | Group-Object ServerName | Foreach-Object{
    $_.Group | Select-Object Software | Export-Csv "$($_.Name).csv" -NoTypeInformation
}

answered Dec 7, 2011 at 12:50

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Shay Levy Over a year ago

Thanks, consider marking it as answered in case it gives you what you need.

Casper Over a year ago

Thanks alot Shay! Working Great! Marked as Answered

Shay Levy Over a year ago

@user978511, you have similar user names :)

Collectives™ on Stack Overflow

Split csv file according to matching columns

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related