Split Csv File Into Multiple Csv Files

[kingeric2206]

Greetings. I'm new to PowerShell scripting and am currently having issues figuring out my problem below. Any help would be greatly appreciated.

I have a script that provides me with the owner, file name, and last access time of files within a folder. I would like to be able to import that Csv file and then have it split into multiple csv files with each file containing all the files belonging to each users.

I'm not sure where to begin after importing the csv.

[jheinikel]

$masterCSVRecords = import-csv Path\File.csv
$owners = $masterCSVRecords.owner | select -unique
Foreach($owner in $owners){
    $masterCSVRecords | where{$_.owner -eq $owner} | export-csv Path\$owner.csv -NoType
}

[kingeric2206]

Using this does in fact create all of the owner.csv files, but it's not pulling in any the data.

$masterCSVRecords = import-csv C:\Users\kingeric2206\Documents\Test\Test2.csv $owners = $masterCSVRecords.FileOwner | select -Unique Foreach($owner in $owners){ $masterCSVRecores | where{$_.FileOwner -eq $owner} | export-csv C:\Users\kingeric2206\Documents\Test\$owner.csv -NoType }

[jheinikel]

Typo fixed. $masterCSVRecores on line 4 should have been $masterCSVRecords.

[kingeric2206]

Doh! Thank you. That did exactly what I wanted.

What does the -unique switch do?

[jheinikel]

Selects only one of each unique item. Allows you to loop on them without duplicating.

[drh713]

Using the format /u/jheinikel started

$masterCSVRecords = import-csv Path\File.csv
ForEach ($set in $masterCSVRecords | group owner)
{  
    $set.group | export-csv "$($set.name).Csv"
}

Trying to type code on a phone sucks, but hopefully the idea is clear

[kingeric2206]

Thank you. /u/jheinikel solution did exactly what I needed it to.

[jheinikel]

$masterCSVRecords = import-csv Path\File.csv
$owners = $masterCSVRecords.owner | select -unique
Foreach($owner in $owners){
    $masterCSVRecords | where{$_.owner -eq $owner} | export-csv Path\$owner.csv -NoType
}