Sort alphabetically

[GarryP]

I have a txt file with a list of 50 to 150 names in a random order, how can I create now file with the same names but listed alphabetically? I have all names converted to lowercase, and each name is on a seperate line.

ie....

blain
bev
malissa
kristen
darlene
trisha
renee
larry
kerry
curtis
keith
maryann


Thanx for any help in pointing me in the right direction,

[Marcus Tettmar]

See the Bubble Sort script in Scripts 'n Tips:
http://www.mjtnet.com/forum/viewtopic.php?t=3414

So, just change inputfile and outputfile and try this:

Code: Select all

Let>inputfile=d:\names.txt
Let>outputfile=d:\names_sorted.txt

ReadFile>inputfile,NamesList
Separate>NamesList,%CRLF%,Names

Let>Max=Names_Count
GoSub>Bubble_Sort

//Write resultant list to a new file
IfFileExists>outputfile
  DeleteFile>outputfile
Endif

Let>i=1
Repeat>i
  Let>thisname=Names_%i%
  WriteLn>outputfile,k,thisname
  Let>i=i+1
Until>i=Max

Run>Notepad.exe %outputfile%

//Sorts Files_x array
//Set Max to number of elements
SRT>Bubble_Sort
  Let>has_swapped=0
  let>i=1
  Repeat>i
         Let>next=i+1
         //change sign on next line to change direction of sort
         if>Names_%i%>Names_%next%
	     Let>store=Names_%i%
	     Let>Names_%i%=Names_%next%
	     Let>Names_%next%=%store%
	     Let>has_swapped=1
	 endif
	 Let>i=i+1
  Until>i=Max
  If>has_swapped=1
     GoSub>Bubble_Sort
  Endif
End>Bubble_Sort

[GarryP]

Works like a charm. I searched to forum for 2 days, and just couldnt find the answer, so when all else fails, ask the pro's. Thanx again.

[D_S]

Have used macro scheduler for a while and love it's capabilities but couldn't a simple DOS sort have done the same thing just as effieciently?

Code: Select all

Let>RP_WAIT=1
Let>RP_WINDOWMODE=0
Run>cmd.exe /c sort test.txt /O testsort.txt

[/code]

[JRL]

Bravo D_S! Macro Scheduler (my favorite software) enhances DOS capabilities as well as VBScript capabilities

I too like DOS... Have I said that before?

[Marcus Tettmar]

Ok, much easier!

As soon as I saw sort I thought of the bubble sort routine I wrote a while back. The DOS method didn't occur to me.

[CyberCitizen]

Have used macro scheduler for a while and love it's capabilities but couldn't a simple DOS sort have done the same thing just as effieciently?

Code: Select all

Let>RP_WAIT=1
Let>RP_WINDOWMODE=0
Run>cmd.exe /c sort test.txt /O testsort.txt

Just wanted to say thank you, I was looking for exactly this option today, to sort a list of Instructor Names. I could of looked at an ArraySort, however as the Instructor Names were already saved in a file & MS is doing the editing, it just means that a sort is run once when the file is saved and not on every launch.

Thanks again.

[armsys]

Just wanted to say thank you, I was looking for exactly this option today, to sort a list of...

Me too. This time, DOS' sorting speed should defeat Marcus' bubble sort.
Thanks, D_S.