Alphabetical Order

[PepsiHog]

Hi there everyone. Been so long since I last logged in that I had to take a second try at my password.

Ok. Soooo.... any way. I need help. But let's talk MS. LOL!!

Does anyone have a formula for putting names in alphabetical order? I need to put actor names in alphabetical order to sort my movies by the actor.

I would think there would be a formula for this. But maybe I'm selling crazy.

Thanks,
PepsiHog

[Djek]

hey PepsiHog,

well, about this problem of yours i am very curious, because i once needed a list sorted so i build it myself.
But i am sure there must be a more normal way to do this.
Anyways, its quick, (because the sorting isnt programmed) and it works.
Just be sure not to have illegal characters in your actor names..

here is my solution:

Code: Select all

//pepsiHog
//
let>tempdir=%SCRIPT_DIR%\tempph
let>sortedfile=%SCRIPT_DIR%\sorted.txt
let>actorlist=James Dean,Schwazzenegger,Sophia Loren,Bing Crosby,Andrew de Groot,Zeger van Oord

Separate>actorlist,%COMMA%,listin
DeleteFolder>tempdir
CreateDir>tempdir

Let>k=0
Repeat>k
  Let>k=k+1
  let>fileout=listin_%k%
  WriteLn>%tempdir%\%fileout%,ert,
Until>k,listin_count
Label>end
let>GFL_SORTTYPE=3
GetFileList>%tempdir%\*.*,listout,#

Separate>listout,#,file_names
DeleteFile>sortedfile
Let>k=0
Repeat>k
  Let>k=k+1
  let>fileout=file_names_%k%
  ExtractFileName>fileout,writeout
  WriteLn>sortedfile,ert,writeout
Until>k,file_names_count

ExecuteFile>sortedfile

kind regards
Djek

[PepsiHog]

Thanks Djek.

[Marcus Tettmar]

Just use the ArraySort function.

[Djek]

much better, Marcus,

i did nt know about that command,

kind regards
Djek