Negative Decimals Won't Sort Correctly using _ArraySort via _FileReadToArray

[msmith11]

Sorting negative decimals with _ArraySort has me baffled.  Trying to sort a 2D array with negative decimals read in thru _FileReadToArray.  Works fine for positive decimals.  For negative decimals preceded by a minus sign however, _ArraySort treats negative decimals as absolute values. The minus sign seems to be ignored.

Any suggestions would be greatly appreciated.  Thanks and best to you.

The  _FileReadToArray Version:

Copy this data to an empty Notepad file and save as Test.csv

CALD,0.0376
AXGN,0.0195
ERII,-0.0243
QRVO,-0.0025
BLDR,-0.0059
WTW,0.0620

;Program start
#include <File.au3>

Local $avArray[6][2] 

_FileReadToArray( "..path\Test.csv", $avArray, 0, "," )  ;YOU'll HAVE TO MODIFY YOUR PATH HERE

_ArrayDisplay($avArray)  ;starting data structure

 _ArraySort($avArray,0,0,0,1)  ;sort ascending on column 1 (the decimals)
_ArrayDisplay($avArray)

 _ArraySort($avArray,1,0,0,1)  ;sort descending on column 1 (the decimals)
_ArrayDisplay($avArray)

;Program End

;Negative Decimal Data acquired thru the UDF _FileReadToArray  will not sort correctly

**********************************************************************************************************

The same program with data entered manually:
#include <File.au3>

Local $avArray[6][2] = [ _
  ["CALD", 0.0376], _
  ["AXGN", 0.0195], _
  ["ERII", -0.0243], _
  ["QRVO", -0.0025], _
  ["BLDR", -0.0059], _
  ["WTW", 0.062]]

_ArrayDisplay($avArray)  ;starting data structure

 _ArraySort($avArray,0,0,0,1)
_ArrayDisplay($avArray)

 _ArraySort($avArray,1,0,0,1)
_ArrayDisplay($avArray)

;Manually entered negative decimals sort correctly

 

 

[msmith11]

I found something that works.  Once the decimals are isolated in their own cells you can datatype them to numbers using the Number function.
 

;New code:
#include <File.au3>

Local $avArray[6][2] 

_FileReadToArray( "..path\Test.csv", $avArray, 0, "," )  ;YOU'll HAVE TO MODIFY YOUR PATH HERE
_ArrayDisplay($avArray)  ;starting data structure

For $i = 0 to 5
       $a_AccumArray[$i][1] = Number( $a_AccumArray[$i][1] )
Next

_ArraySort($avArray,0,0,0,1)  ;sort ascending on column 1 (the decimals)
_ArrayDisplay($avArray)

_ArraySort($avArray,1,0,0,1)  ;sort descending on column 1 (the decimals)
_ArrayDisplay($avArray)

 

 

[Melba23]

msmith11,

you can datatype them to numbers

That is the only way to get numbers to sort "correctly" - otherwise they are sorted as strings.

M23