Re: TLE sort in spreadsheet

From: Björn Gimle via Seesat-l <seesat-l_at_satobs.org>
Date: Tue, 1 Jan 2019 01:57:54 +0100
Hello Jay, Happy New Year !
I have four ideas:
In the past I use qsort.exe which supports multiline or delimited records,
and character count sort fields.
In UltraEdit it is fairly easy to write a macro to combine line 1+2+0, sort
on fields, then split into 3LE again.
In W10 the sort command has character count fields, but I don't know about
multiline. So UltraEdit may once again solve that part.
In Excel I used to solve programming with VBA, but Microsoft does not allow
me to install VBA on my new computer with my ancient license due to
"support terminated" - I have to use and pay a contemporary version!?

I'll see what I find out in a few days.

Björn

måndag 31 december 2018 skrev J Respler via Seesat-l <seesat-l_at_satobs.org>:

>
> Another idea.
> If I import a set of tle into Excel spreadsheet, is there a way to sort
> those paragraphs by a specific field such as MM or incl?
> That would have to be a sort of every 3 lines by just one word anywhere in
> that set.
>
> --
> Jay Respler
> JRespler_at_superlink.net
> Monroe Township, New Jersey
>
> _______________________________________________
> Seesat-l mailing list
> http://mailman.satobs.org/mailman/listinfo/seesat-l
>


-- 
--------------------------------------------------------
Björn Gimle, COSPAR 5919
59.2617 N, 18.6169 E, 51 m
Satellite observation formats described:
http://www.satobs.org/position/IODformat.html
---------------------------------------------------------
_______________________________________________
Seesat-l mailing list
http://mailman.satobs.org/mailman/listinfo/seesat-l
Received on Mon Dec 31 2018 - 18:58:48 UTC

This archive was generated by hypermail 2.3.0 : Tue Jan 01 2019 - 00:58:49 UTC