javascript delimited column sort

[trix1210]

Thanks for reading..

I have a file called recs.js

It contains many records like this (each on a new line):

A("TV1219|cent53t|10 Revolutions|Time For The Revolution|incentive|5|trance|08/2003|3");
A("TV150|12txr004|2 digital|because of my dreams|triple xxx recordings|10|house|zz/1999|2");
A("TV1007|12tiv-32|2 in a room|Ahora Es (Now Is The Time)|positiva|5|house|zz/1995|5");
A("TV1271|12sbk 19|2 in a room|wiggle it|sbk records|7|oldskool|zz/1990|3");
A("TV513|nebdj059|4 strings|turn it around|nebula|5|dance|zz/2004|2");


The field data are separated by the bar character (|)

The fieldnames are: product code, catnum, artist, title, label, price, genre, release, numtrax.

(A is a function which I call which loads the data into an array)

I need a function I can call which will sort by whichever column the user chooses i.e. title or label.

Any help greatly appreciated!

Trixy

 

[IMM]

Are you trying this with a 1 dimensional array or have you loaded it into a 2D array ?

 

[trix1210]

one dimensional

 

[IMM]

I think I'd give up the 1D array for this (if you really want to sort on columns and use js arrays).
You should probably try a 2D array along the lines discussed at http://www.webxpertz.net/forums/showthread.php?t=9965 (as an example)

For a discussion of non-alphabetic sorts (I think I see some numeric columns in your stuff) you might look at http://www.javascriptkit.com/javatutors/arraysort.shtml (and the link at the bottom)
I hope this helps.