Batch to copy then sort csv file

[*JimmyJ*]

evening guys, need some help. I'm trying to write a batch file which will copy a .csv file but also sort the contents of it. Any ideas, or help please.

 

[Adam.]

Deltree

 

[*JimmyJ*]

pardon...

 

[@Spoonie]

pardon...

What O/S, what's in the CSV?

 

[*JimmyJ*]

windows 7, it's just going to be basic text. Two columns, first column with a number, and the second column with a name.

 

[@Spoonie]

windows 7, it's just going to be basic text. Two columns, first column with a number, and the second column with a name.

Single line in PowerShell - I am assuming its in a subfolder of C:\ called MyData and you want to sort on Name column

PS C:\MyData> $mycsv = Import-Csv .\Source.csv | Sort-Object -Property Name -Descending | Export-Csv NameSorted.csv -NoTypeInformation

The | are pipes.

 

[*JimmyJ*]

Cheers Spoonie. When i run the ps script it creates the secondary file but the file is all alien text. any ideas....

 

[@Spoonie]

Not sure, could be encoding. You can split the command up:

PS C:\MyData> $mycsv = Import-Csv .\Source.csv
PS C:\MyData> $mycsv | Sort-Object -Property Name -Descending

Does that print out to the screen as expected?

 

[*JimmyJ*]

Nop, my fault. Got it producing the file but its not sorting it correct. Below is a simple of the original and the output file it produces

Number Name
21 John
43 Mark
2 Ed
1 Ellen
100 Steven
89 Michael

Number Name
89 Michael
43 Mark
21 John
2 Ed
10 Steven
1 Ellen

What am i doing wrong

 

[@Spoonie]

What's the output from the following:

PS C:\MyData> $mycsv = Import-Csv .\Source.csv
PS C:\MyData> $mycsv | Get-Member

EDIT: Its these you want to check:

PS C:\> $mycsv | Get-Member

TypeName: System.Management.Automation.PSCustomObject
Name MemberType Definition
---- ---------- ----------
Equals Method bool Equals(System.Object obj)
GetHashCode Method int GetHashCode()
GetType Method type GetType()
ToString Method string ToString()
[B]Name NoteProperty System.String Name=John
Number NoteProperty System.String Number=21[/B]

That is the property it will try and sort on, not sure why yours isn't sorting. Mine:

PS C:\> $mycsv | Sort-Object -Property Name -Descending
Number Name
------ ----
100 Steven
89 Michael
43 Mark
21 John
1 Ellen
2 Ed