I need to be able to put in 200 names separated by new lines (firstName lastName) into a textbox and I need the second textbox to show me all these 200 names alphabetically ordered with the format of (lastName, firstName). I’ve tried many array functions (sort for example) but couldnt get it right.
If the lastName, firstName format is not possible, i’d just like it to at least reshuffle the first textbox and show all the inputs in an alphabetical order in the second textbox in firstName lastName format.
For example, I type in the following exactly how it shows (with new lines per name):
John Hoe
George Glooney
Suede Jubuck
Panda Iris
Shawn Hamilton
I press the order button and the 2nd textbox shows me:
Glooney, George
Hamilton, Shawn
Hoe, John
Iris, Panda
Jubuck, Suede
Notice it goes by G-H(ha,ho)-I-J here, obviously. If this cannot be done, I’d like first name ordering:
George Glooney
John Hoe
Panda Iris
Shawn Hamilton
Suede Jubuck
The comma’s arent necessary, at all, but it’s a nice fix. Any other suggestions are welcome. Thanks.
