Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

Coding Forum


You are currently viewing our Coding Forum as a guest. Please register to participate.
Login



Reply
Need a program that sorts a text list by number of characters in ascending order....
Old 05-08-2007, 01:31 AM Need a program that sorts a text list by number of characters in ascending order....
Junior Talker

Posts: 2
Trades: 0
Hello,

I have a huge list of text and I want to organize it so that it will put them in ascending order for instance

L2
Lis5555
Li777
List33333

will go

L2
Li777
Lis5555
List33333

for all of them.

Someone made me a program but it's made in VB and everytime I load a huge list it will freeze on me. :\

I've heard excel does it but I tried it and all it does is put it ascending order on some of them. Not throughout the whole list.
cobracommander is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 05-08-2007, 03:35 AM Re: Need a program that sorts a text list by number of characters in ascending order.
JeremyMiller's Avatar
WT Moderator

Posts: 1,712
Name: Jeremy Miller
Location: Las Vegas, NV
Trades: 0
If you can use Excel, why not create a column whose value is =len(YOUR_COL) and then sorting by the YOUR_COL column?
__________________
Jeremy Miller

Please login or register to view this content. Registration is FREE
JeremyMiller is offline
Reply With Quote
View Public Profile Visit JeremyMiller's homepage!
 
Old 05-08-2007, 09:52 AM Re: Need a program that sorts a text list by number of characters in ascending order.
Junior Talker

Posts: 2
Trades: 0
How do I change the column's value?
cobracommander is offline
Reply With Quote
View Public Profile
 
Old 05-12-2007, 11:49 AM Re: Need a program that sorts a text list by number of characters in ascending order.
Novice Talker

Posts: 5
Trades: 0
if you use excel...you need to assign each entry a # vaule in a parrell column and sort by # instead of text.. it seemed to work better for me..

i have a php code that will do this if you have database...

Last edited by Winn; 05-12-2007 at 12:31 PM..
Winn is offline
Reply With Quote
View Public Profile
 
Old 05-12-2007, 04:04 PM Re: Need a program that sorts a text list by number of characters in ascending order.
ForrestCroce's Avatar
Half Man, Half Amazing

Posts: 3,023
Name: Forrest Croce
Location: Seattle, WA
Trades: 0
Excel will do the whole list as long as there are less than 65,000 entries. You have to put them into a column, and then select all of them, though. Also, because there's text in your codes, it will sort based on alpha, not numerics, so 10 is less than 9.

Where does the list come from?
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
ForrestCroce is offline
Reply With Quote
View Public Profile Visit ForrestCroce's homepage!
 
Old 05-17-2007, 12:30 PM Re: Need a program that sorts a text list by number of characters in ascending order.
willcode4beer's Avatar
Super Moderator

Posts: 1,533
Name: Paul Davis
Location: San Francisco
Trades: 1
How big is "huge" ?
__________________

Please login or register to view this content. Registration is FREE

willcode4beer is offline
Reply With Quote
View Public Profile
 
Old 05-18-2007, 06:30 AM Re: Need a program that sorts a text list by number of characters in ascending order.
Skilled Talker

Posts: 60
Name: bilton
Trades: 0
save the list in a mysql table. then query using a select statement
SELECT Coloum1, Coloum2
FROM table ORDER BY Coloum1 ASC
niceguy_81333 is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to Need a program that sorts a text list by number of characters in ascending order....
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.79698 seconds with 12 queries