JS Sort Function

[Fawke101]

Hi there,

I have a JS/ASP application that sorts a SQL populated table.
This works great, and sorts the data fine, apart from my currency columns.
It wants to read the data as text as far as i can gather. Ths data in ASP
looks like this -
<% =formatcurrency (RS("income"),2 )%>

I have tried changing this to a number (formatnumber) and hard coding a £
sign, yet it still wants to read the data as text, rather than numerical?
How can i get my JS function to read currency or if not, eliminate the
forehand figures. I need the data to appear as a currency, yet be sorted as
a number (rather than taking the 2st digit)

If it would help i can post my JS script, but i was wondering if this is a
common problem (sorting currency) and there was a universal solution around
this.

Thanks

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

[David Morgan]

It all depends where you're doing the sort. I think the JS function would
be useful.
"Fawke101" <gu*@ANTIbradfl ack.SPAMcom> wrote in message
news:uS******** ******@TK2MSFTN GP11.phx.gbl...

Hi there,

I have a JS/ASP application that sorts a SQL populated table.
This works great, and sorts the data fine, apart from my currency columns.
It wants to read the data as text as far as i can gather. Ths data in ASP
looks like this -
<% =formatcurrency (RS("income"),2 )%>

I have tried changing this to a number (formatnumber) and hard coding a £
sign, yet it still wants to read the data as text, rather than numerical?
How can i get my JS function to read currency or if not, eliminate the
forehand figures. I need the data to appear as a currency, yet be sorted as a number (rather than taking the 2st digit)

If it would help i can post my JS script, but i was wondering if this is a
common problem (sorting currency) and there was a universal solution around this.

Thanks

--
Thanks in advance

Fawke

Please remove ANTI and SPAM
from my email address before emailing me.

www.bradflack.com

[Lasse Reichstein Nielsen]

"Fawke101" <gu*@ANTIbradfl ack.SPAMcom> writes:

I have a JS/ASP application that sorts a SQL populated table.
This works great, and sorts the data fine, apart from my currency columns.
It wants to read the data as text as far as i can gather. Ths data in ASP
looks like this -
<% =formatcurrency (RS("income"),2 )%>

I have tried changing this to a number (formatnumber) and hard coding a £
sign, yet it still wants to read the data as text, rather than numerical?

The sort function can sort anything, provided the appropriate
comparison function. However, the default comparison function converts
its arguments to strings and does lexical comparison. So, you must supply
the comparison function for your numbers.
E.g.:

// convert currency string to number (ignores prefixed £ and $, but
// can be extended)
function valueOfCurrency (string) { // zero or two decimals
if (match = /^[$£](\d+)(\.(\d\d)) ?$/.exec(string)) {
return Number(match[1])*100 + Number(match[3]); // pence or cent
}
return -1;
}

function compareCurrency (a,b) {
return valueOfCurrency (a)-valueOfCurrency (b);
}

var money = ["$24.20","$1000 000","$125.95", "$1.25"];
alert(money.sor t(compareCurren cy));
/L
--
Lasse Reichstein Nielsen - lr*@hotpop.com
DHTML Death Colors: <URL:http://www.infimum.dk/HTML/rasterTriangleD OM.html>
'Faith without judgement merely degrades the spirit divine.'