Sort 2d array numerical

[rony2006]

Hello,

I have a problem: Basically i want to sort a 2d array using one column that contains numeric values.

My code looks like this:

For $iz = 1 To UBound($CCinvoices) -1

$CCinvoices[$iz][1] = StringReplace($CCinvoices[$iz][1], " ", "")
$CCinvoices[$iz][1] = Number($CCinvoices[$iz][1])


Next






_Arraydisplay($CCinvoices, "$CCinvoices")

_ArraySort($CCinvoices, 1, 0, 0,1)



_Arraydisplay($CCinvoices, "$CCinvoices")

 

This is how array looks before sorting.

 

 

 

After i sort the array, I got the following result:

As you see 227.21 was sorted after 29.79 so i dont know why i got this.

 

I tried the following solutions:

1) Removing blank spaces

2) Converting strings to Number before sorting.

 

Any ideas?

 

Edited April 4, 2019 by rony2006

[Melba23]

rony2006,

Converting the strings to numbers should give you a numerical sort. Can you please post the code that you used to convert the column - perhaps that might be helpful to see where it has gone wrong.

M23

[Gianni]

rony2006 , if your conversion loop is that in the first post (For $iz = 1 to ...), you should try to start the for/next loop from 0 instead of from 1