asked on
VBscript to sort a CSV fille
I need a to automate the soriting of a CSV file (with headers.)
I need it to first sort by colum 2 and then reverse sort by colum J.
example.csv
I need it to first sort by colum 2 and then reverse sort by colum J.
example.csv
VB ScriptPowershell
Last Comment
Mike Satterfield
ASKER
this will be part of an automated process.. thats why i'm looking for a commandline solution.
Can sort it with powershell, Thank you for the link. but i am not able to reverse sort for the 10th coloum.
Can sort it with powershell, Thank you for the link. but i am not able to reverse sort for the 10th coloum.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
That worked Great!.
Thank you!
Thank you!
If you really need a command line capability then here is a nice freeware utility I have used:
http://www.chmaas.handshake.de/delphi/freeware/cmsort/cmsort.htm
And of course Powershell can do this quite easily as well:
https://blogs.technet.microsoft.com/heyscriptingguy/2013/07/11/use-powershell-to-sort-csv-files-in-order/
~bp