Sorting Arrays from Readfile / Writefile

[JPF 0]

Hi everybody,

As you can probably tell i'm quite new to Autoit and seek your expertise and guidance!

I have been given a challenge to read a set of numbers from a text file, have them sorted in descending order and write them to a seperate text file, or a message box

The problem i'm having seems to be with the _Arraysort function, maybe?

This is what I have tried so far.. dont laugh

Dim $temp[5] =[FileRead("numero.txt")]

_ArraySort($temp, 1)

FileWrite("dupe.txt", $temp)

Can anybody shed any light on this? It doesn't seem like enough but the help file hasn't been too kind to me either

Much appreciated!

Edited March 27, 2011 by JPF

[water 2,385]

#Include <File.au3>
#include <array.au3>
Global $aArray
_FileReadToArray("numero.txt", $aArray) 
_ArraySort($aArray, 1, 1)
_FileWriteFromArray("dupe.txt", $aArray, 1)

Edited March 27, 2011 by water

[JPF 0]

#Include <File.au3>
#include <array.au3>
Global $aArray
_FileReadToArray("numero.txt", $aArray) 
_ArraySort($aArray, 1, 1)
_FileWriteFromArray("dupe.txt", $aArray, 1)

Hi Water, thanks for the code!

The only thing that happens there is the numbers that come back don't get sorted

In the 'Numero' text file, I have simply typed = 1 2 8 4 9

What comes back into the 'Dupe' file is = 1 2 8 4 9

Any suggestions?

[UEZ 1,272]

Try this:

#include <Array.au3>
$dest = ""
$hFile = FileOpen("numero.txt")
While True
    $line = FileReadLine($hFile)
    If @error = -1 Then ExitLoop
    $aNumbers = StringSplit($line, " ", 2)
    _ArraySort($aNumbers)
    $dest &= _ArrayToString($aNumbers, " ") & @CRLF
WEnd
FileClose($hFile)
$hFile = FileOpen("Dupe.txt", 2)
FileWrite($hFile, $dest)
FileClose($hFile)

Br,

UEZ

[water 2,385]

What do you need to sort? The lines (rows) in the file or the numbers in each line?

[JPF 0]

What do you need to sort? The lines (rows) in the file or the numbers in each line?

I need to sort the numbers in descending order

The previous poster has sorted it, it does work now! (Many thanks!!) I just dont really understand the code very well...

Water, if i add stringsplit to your code will that also work?

[water 2,385]

Water, if i add stringsplit to your code will that also work?

No, my code sorts lines, UEZ's code sorts the "words" in a line.

In Excel: UEZ's code sorts the columns whereas my code sorts the lines.

[UEZ 1,272]

The question is how are the numbers saved in the text file?

If the numbers are in each line then you have to read each line and sort it! If the numbers are in each row then you can use Water's code.

Br,

UEZ

[JPF 0]

The question is how are the numbers saved in the text file?

If the numbers are in each line then you have to read each line and sort it! If the numbers are in each row then you can use Water's code.

Br,

UEZ

Guys, totally understand it now! thats perfect

Thanks again! Understanding this has been abit of a mare :)