Re: Need to sort a very large list of words

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.

.

Relevant Pages

  • Re: Need to sort a very large list of words
    ... Then pull out using ORDER BY clause and ... write to output file. ... I figure I'll write a program to sort the file. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Need to sort a very large list of words
    ... Thanks to all but the first reply about the command line sort utility worked ... Then pull out using ORDER BY clause and ... write to output file. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: basic ?id=x question
    ... i had the sort before the where clause and that messed it ... > I'm trying to pull from a database... ...
    (php.general)
  • Re: How top actually works
    ... So the next one shows that order by clause has affected the result set ... sort these N rows according to my order by clause. ... Ie. you are telling SQL Server ... This is much the same as with rownum in Oracle, ...
    (comp.databases.ms-sqlserver)
  • Re: Order of records in table as a result of a Query
    ... That is a whole world of difference in the meaning "not important": ... Why don't you simply export the results of your query? ... AL EXPORT in the same order as they exist in AL EXPORT SORT. ... ORDER BY clause is not being used at all. ...
    (microsoft.public.access.queries)