Sort utility other than SORT.EXE?

  • Thread starter Thread starter Rick
  • Start date Start date
R

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.
 
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
 
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 said:
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.
Click to expand...

Are you saying that your columns are of fixed width? If so, what is the
starting location and width of each columnn?
 
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.
 
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...
Click to expand...
 
Rick said:
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.
Click to expand...

Try to use MySQL.
 
Back
Top