You are on he right track Chrismo, except that somehow he needs to be able to select three lines as the "chunk" that stays together, and then gets sorted as those "chunks" by the data in one cell within that chunk. Moving it all to one line would make the sort work, but you would need to automate moving all the info on each set of three lines to one line, and then have it move back to the three line format when the sort is over. I am sure there is a way to do this, but I don't know what it is off the top of my head. I would love to see the solution if anyone figures it out! Jo Quoting Chrismo <djchrismo@gmail.com>:
I believe the way to do that is first select the column to sort by, then 'select all' and then do the sort
On Monday, May 7, 2012, Patrick Wiggins wrote:
Howdy folks,
I'm trying to use Excel to sort data by right ascension while at the same time keep the format of the original file.
What I'd like to be able to do is input this (as generated by the target selection and scripting feature of TheSky):
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
And then have it come out sorted like this:
SlewToObject, NGC 1961, 5.72365 69.38635 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2146, 6.34319 78.35322 WaitFor , 5 , TakeImage , 30 ,
SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
Note that it's sorted by the number in the third column with everything else remaining the same.
Any ideas?
Thanks,
patrick _______________________________________________ Utah-Astronomy mailing list http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
Send messages to the list to Utah-Astronomy@mailman.xmission.com <javascript:;>
The Utah-Astronomy mailing list is not affiliated with any astronomy club.
To unsubscribe go to: http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Then enter your email address in the space provided and click on "Unsubscribe or edit options".
-- Sent from my iPad _______________________________________________ Utah-Astronomy mailing list http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy
Send messages to the list to Utah-Astronomy@mailman.xmission.com
The Utah-Astronomy mailing list is not affiliated with any astronomy club.
To unsubscribe go to: http://mailman.xmission.com/cgi-bin/mailman/listinfo/utah-astronomy Then enter your email address in the space provided and click on "Unsubscribe or edit options".