Multiple column sorting

5 replies
1654 views
Translate All

Hi,

It is easy using the csort(M,n) command but it only operates on one column.

Is there an easy way to sort on first two columns.

Also need to add if first two columns are identical ?

Thanks

Other

S

StuartBruffAnswer

23-Emerald V

I think there have been a couple of threads on this issue. Tom Gutman, one of the old cadre, wrote one using rank sort. Here's a thread in which @RichardJ and @LucMeekes give solutions (Richard's was an improvement on Tom's, and Luc's is different - AFAICT, just scanning the message. I haven't looked at the worksheets, but if they're by Tom, Richard, and Luc, the routines should be more than good enough for most purposes (Luc's handles larger matrices more reliably)

https://community.ptc.com/t5/Mathcad/Csort-is-it-true/m-p/706968/highlight/true#M193865

By an interesting coincidence, I'm in the process of updating an old complex-number mergesort worksheet of mine to MP10. I'm also fiddling around with it to see if I can get it to sort on functions ... no idea what the sorting criterion should be.

Stuart

S

StuartBruff

Answer

23-Emerald V

I think there have been a couple of threads on this issue. Tom Gutman, one of the old cadre, wrote one using rank sort. Here's a thread in which @RichardJ and @LucMeekes give solutions (Richard's was an improvement on Tom's, and Luc's is different - AFAICT, just scanning the message. I haven't looked at the worksheets, but if they're by Tom, Richard, and Luc, the routines should be more than good enough for most purposes (Luc's handles larger matrices more reliably)

https://community.ptc.com/t5/Mathcad/Csort-is-it-true/m-p/706968/highlight/true#M193865

By an interesting coincidence, I'm in the process of updating an old complex-number mergesort worksheet of mine to MP10. I'm also fiddling around with it to see if I can get it to sort on functions ... no idea what the sorting criterion should be.

Stuart

Translate