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
Alphabetical Order
Moderators: Dorian (MJT support), JRL
Alphabetical Order
Windows 7
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2021) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2021) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
Re: Alphabetical Order
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:
kind regards
Djek
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
Djek
Re: Alphabetical Order
Thanks Djek.
Windows 7
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2021) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
PepsiHog. Yep! I drink LOTS of Pepsi (still..in 2021) AND enjoy programming. (That's my little piece of heaven!)
The immensity of the scope of possibilities within Macro Scheduler pushes the user beyond just macros!
- Marcus Tettmar
- Site Admin
- Posts: 7380
- Joined: Thu Sep 19, 2002 3:00 pm
- Location: Dorset, UK
- Contact:
Re: Alphabetical Order
Just use the ArraySort function.
Marcus Tettmar
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
http://mjtnet.com/blog/ | http://twitter.com/marcustettmar
Did you know we are now offering affordable monthly subscriptions for Macro Scheduler Standard?
Re: Alphabetical Order
much better, Marcus,
i did nt know about that command,
kind regards
Djek
i did nt know about that command,
kind regards
Djek