473,546 Members | 2,308 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Need to sort a very large list of words

I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.
Jan 8 '07 #1
10 3481
" Frank" <fr***@a-znet.comwrote in message news:OZ******** *****@TK2MSFTNG P04.phx.gbl...
>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.


Why not use the command line utility sort.exe?

Willy.

Jan 8 '07 #2

" Frank" <fr***@a-znet.comwrote in message
news:OZ******** *****@TK2MSFTNG P04.phx.gbl...
>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Suggestion, first pigeonhole the data, by reading one line at a time, and
putting all the As in one file, Bs in another, etc, without worrying about
sorting. Then, sort each file independently, then catenate all the files
back together.
>

Thanks in advance.

Jan 8 '07 #3
I'll bite... what does "too large" mean?

Is there some actual number of words you might let us in on? I don't mean
to sound silly but if it is gazillion you'd probably run into different
problems than if it was just .5 gazillion. Other than that are you sorting
it in realtime, once per hour, once per day, on demand, this one time and
then who cares?

" Frank" <fr***@a-znet.comwrote in message
news:OZ******** *****@TK2MSFTNG P04.phx.gbl...
>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.

Any helpful comments?
Thanks in advance.

Jan 8 '07 #4
I didn't know it existed. I'll try

thanks

"Willy Denoyette [MVP]" <wi************ *@telenet.bewro te in message
news:Ow******** ******@TK2MSFTN GP04.phx.gbl...
>" Frank" <fr***@a-znet.comwrote in message
news:OZ******* ******@TK2MSFTN GP04.phx.gbl...
>>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word
and asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.


Why not use the command line utility sort.exe?

Willy.

Jan 8 '07 #5
Thanks, I think I'll try the suggestion from Willy then Ben if needed
"Tom Leylan" <tl*****@nospam .netwrote in message
news:er******** ******@TK2MSFTN GP06.phx.gbl...
I'll bite... what does "too large" mean?

Is there some actual number of words you might let us in on? I don't mean
to sound silly but if it is gazillion you'd probably run into different
problems than if it was just .5 gazillion. Other than that are you
sorting it in realtime, once per hour, once per day, on demand, this one
time and then who cares?

" Frank" <fr***@a-znet.comwrote in message
news:OZ******** *****@TK2MSFTNG P04.phx.gbl...
>>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word
and asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.

Any helpful comments?
Thanks in advance.


Jan 8 '07 #6
Good idea, thanks
"Ben Voigt" <rb*@nospam.nos pamwrote in message
news:%2******** *******@TK2MSFT NGP04.phx.gbl.. .
>
" Frank" <fr***@a-znet.comwrote in message
news:OZ******** *****@TK2MSFTNG P04.phx.gbl...
>>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word
and asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?

Suggestion, first pigeonhole the data, by reading one line at a time, and
putting all the As in one file, Bs in another, etc, without worrying about
sorting. Then, sort each file independently, then catenate all the files
back together.
>>

Thanks in advance.


Jan 8 '07 #7
I would create a table in SQL2005 Express and read each word line at a
time into the data table. Then pull out using ORDER BY clause and
write to output file.

Something like this gets even easier with a software like LLBLGenPro
(http://llblgen.com) I imagine this could all be done in a matter of 5
mins. or less :)
Frank wrote:
I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.
Jan 9 '07 #8
Or he could lease time on Deep Blue. But why would he need an OR mapper to
sort a list of words?

I don't believe anybody knows why he wants to do it in which case an old
copy of FoxPro can sort them as could any number of free database tools.
The last thing on my list would have been Word, I didn't even know Word
could do such a thing. If I wanted MS Office to do it I might have given
Excel a shot at it. :-)

"Sir C4" <Va*******@gmai l.comwrote in message
news:11******** **************@ i15g2000cwa.goo glegroups.com.. .
>I would create a table in SQL2005 Express and read each word line at a
time into the data table. Then pull out using ORDER BY clause and
write to output file.

Something like this gets even easier with a software like LLBLGenPro
(http://llblgen.com) I imagine this could all be done in a matter of 5
mins. or less :)
Frank wrote:
>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word
and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.

Jan 9 '07 #9
"Sir C4" <Va*******@gmai l.comwrote in message
news:11******** **************@ i15g2000cwa.goo glegroups.com.. .
>I would create a table in SQL2005 Express and read each word line at a
time into the data table. Then pull out using ORDER BY clause and
write to output file.

Something like this gets even easier with a software like LLBLGenPro
(http://llblgen.com) I imagine this could all be done in a matter of 5
mins. or less :)

If you are familiar with it. I may try it just to learn about SQL

Thanks

>

Frank wrote:
>I have a text file, one word per line.
I want to arrange the lines alphabetically so I opened it into MS Word
and
asked Word to sort it.
Word said that the list was too big for it.
I figure I'll write a program to sort the file.
But I wonder if Word can't handle it what things I'll run into and what's
the best way to proceed.

I have no idea what kind of limits the are on array sizes and such.
Any helpful comments?
Thanks in advance.

Jan 10 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2273
by: Kamilche | last post by:
I've written a generic sort routine that will sort dictionaries, lists, or tuples, either by a specified key or by value. Comments welcome! import types def sort(container, key = None, ascending = True): ' Sort lists or dictionaries by the specified key' t = type(container)
1
2905
by: DJTB | last post by:
zodb-dev@zope.org] Hi, I'm having problems storing large amounts of objects in a ZODB. After committing changes to the database, elements are not cleared from memory. Since the number of objects I'd like to store in the ZODB is too large to fit in RAM, my program gets killed with signal 11 or signal 9... Below a minimal working (or...
3
10616
by: google | last post by:
I have a database with four table. In one of the tables, I use about five lookup fields to get populate their dropdown list. I have read that lookup fields are really bad and may cause problems that are hard to find. The main problem I am having right now is that I have a report that is sorted by one of these lookup fields and it only displays...
8
1762
by: Ben Fidge | last post by:
Hi I'm working on a site which requires the users to specify a hotel at which they're staying in London. The complete list of hotels comes to something like 1600 records. Each record consists of Hotel Name, Street Address and Postcode. We need to make it as simple as possible for users to pick their hotel, but I don't want to put 1600...
4
2184
by: naknak4 | last post by:
Introduction This assignment requires you to develop solutions to the given problem using several different approaches (which actually involves using three different STL containers). You will implement all three techniques as programs. In these programs, as well as solving the problem, you will also measure how long the program takes to...
6
2112
by: naknak | last post by:
Introduction This assignment requires you to develop solutions to the given problem using several different approaches (which actually involves using three different STL containers). You will implement all three techniques as programs. In these programs, as well as solving the problem, you will also measure how long the program takes to...
20
4235
by: mike | last post by:
I help manage a large web site, one that has over 600 html pages... It's a reference site for ham radio folks and as an example, one page indexes over 1.8 gb of on-line PDF documents. The site is structured as an upside-down tree, and (if I remember correctly) never more than 4 levels. The site basically grew (like the creeping black...
3
3197
by: dotyet | last post by:
Hello Everyone, I have a mixed workload DB2 UDB 8.2 FP 14 Windows x64 database. The database performs as per the expectations. I have just one small question. The sort related parameters are configured as follows: Sort heap threshold (4KB) (SHEAPTHRES) = 50000 Sort list heap (4KB) (SORTHEAP) = 4096...
4
1776
by: kj | last post by:
I'm downloading some very large tables from a remote site. I want to sort these tables in a particular way before saving them to disk. In the past I found that the most efficient way to do this was to piggy-back on Unix's highly optimized sort command. So, from within a Perl script, I'd create a pipe handle through sort and then just print...
0
7504
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7435
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7694
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7947
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
7792
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5080
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3470
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1921
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
747
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.