Sort utility other than SORT.EXE?

[Rick]

Hope someone can help with this. I have a comma-delimited text file
with some 200,000 rows. Each row is 186 chars long. I need to have
these rows sorted, and then sent to another file, on both a primary and
a secondary sort. Is there a utility that can do this? The primary
sort needs to be on the last comma-delimited column (position 179-186),
and the secondary sort needs to be on the comma-delimited column that
lies between position 137-150.

I can't think of any way to do this. Thanks for any help.

 

[Daniel]

You can load .txt files into Excel and sort there,
if you are not familiar with this give it a go anyway,
Excel takes care of it all quite intuitively.

regards

Daniel

 

[Rick]

Ouch! I figured it was the perfect solution ... until Excel told me
"File not loaded completely". Apparently Excel can't open a file
containing more than 65,536 rows. Hmmm...

 

[Pegasus \(MVP\)]

Hope someone can help with this. I have a comma-delimited text file
with some 200,000 rows. Each row is 186 chars long. I need to have
these rows sorted, and then sent to another file, on both a primary and
a secondary sort. Is there a utility that can do this? The primary
sort needs to be on the last comma-delimited column (position 179-186),
and the secondary sort needs to be on the comma-delimited column that
lies between position 137-150.

I can't think of any way to do this. Thanks for any help.

Are you saying that your columns are of fixed width? If so, what is the
starting location and width of each columnn?

 

[Rick]

Yup, they're fixed width.

The primary sort needs to be on the 'column' that starts at position 179
and is 8 chars wide (this is the last column), and the secondary sort
should start at position 137 and is 13 chars wide.

Thanks for any help.

 

[Bob I]

Excel 2007 can do it ;-)

Ouch! I figured it was the perfect solution ... until Excel told me
"File not loaded completely". Apparently Excel can't open a file
containing more than 65,536 rows. Hmmm...

 

[Rick]

Aw, don't rub it in )

Excel 2007 can do it ;-)

 

[Pegasus \(MVP\)]

Google is your friend. If you type this into a Google search box

command line sort

then you will immediately trip over this link:
http://www.chmaas.handshake.de/delphi/freeware/cmsort/cmsort.htm
Just for fun I sorted a 220,000 line text file with the command below - it
worked very nicely!

cmsort /c=21,10 /c=17,2 d:\input.txt d:\output.txt /b

 

[Tim Slattery]

Excel 2007 can do it ;-)

Yes, that limit is gone in Excel 2007. Anybody know whether Open
Office's spreadsheet has a limit like that?

 

[Rick]

Fabulous. Thank you.

 

[Pegasus \(MVP\)]

Thanks for the feedback.

Fabulous. Thank you.

 

[St]

Hope someone can help with this. I have a comma-delimited text file
with some 200,000 rows. Each row is 186 chars long. I need to have
these rows sorted, and then sent to another file, on both a primary and
a secondary sort. Is there a utility that can do this? The primary
sort needs to be on the last comma-delimited column (position 179-186),
and the secondary sort needs to be on the comma-delimited column that
lies between position 137-150.

I can't think of any way to do this. Thanks for any help.

Try to use MySQL.

 

[3c273]

Yes, that limit is gone in Excel 2007. Anybody know whether Open
Office's spreadsheet has a limit like that?

65,536 row in OOO.
Louis