Problem in Sorting - When Using Currency Symbol

I am facing problem in sorting [only] when using currency symbol along with data/values;

Problem:
£10.5
£11.6
£5.6 (Without currency symbol, sorting works fine)
£6.3

But works fine for values;
£0.01
£0.02
£0.03

An urgent help in the above matter will be highly appreciated.

Values after sorting;
£10.5
£11.6
£5.6
£6.3 (Without currency symbol, sorting works fine)

Alex, could you please help!!!!!!!

Are you storing the information in the array as £11.6 or 11.6? I suggest that you store the information in numeric format then use a format statement to display it with the £.
That is what I would try. I have not tried it to solve your problem but I think it would hlp.

This will work fine if the values use single currency symbol but if values are something like:

£10.5
$11.6
£5.6 (Without currency symbol, sorting works fine)
$6.3

I want to sort it by values, required result is:

£5.6
$6.3
£10.5
$11.6
Due to different currency symbol i cant use format statement.
Jim can u please give me the solution of this problem?

I tried to apply format statement but it didnt work.Is there any other idea?

var number = new Active.Formats.Number;
number.setTextFormat("$ #.##"); //not working
obj.setCellFormat(number, 4);

Sorting works fine on this column but no currency symbol with values.

Alex/Jim, Any help on the above problem. We need urgent help in the above matter to move forward with the AW2.0, as this issue is blocker and we are unable to implement AW in our reporting system along with the above "sorting problem when using currency symbol".

Looking forward for any workaround or tip!!

If you do a search of the forum, I think you will find mention of a technique to use a different column (hidden) to actually sort on even though you are clicking columnX. With that technique (or override the sort method, I think there is also a post about that) use the JavaScript function parseFloat to get just the numeric value out of your string. Here is a link to a page that tells you how to use parseFloat http://www.javascripter.net/faq/convert2.htm . I hope this will help you out.

Fahad,

when you supply your data as text but want it to be sorted as numeric values - you have to provide both text AND values (or provide a function which converts text to numeric values):

obj.setCellText(myData);
obj.setCellValue(function(col, row){
    return parseFloat(myData[row][col].replace(/[^0-9.]/m, ""));
}, 2);

This code fixes sorting in /examples/old/basic.htm, Market Cap. column. The RegExp removes all non-digit characters (except ".") and parseFloat function converts the result to numeric value.

Fahad/Shakir,

I've used the script below and works fine so far at my side:

obj.setCellValue(function(col, row){
return parseFloat(myData[row][col].replace(/[^0-9.]/m, ""));
}, columnNumber);

Alex,

Thanks for you help.

Highly appreciated!