Not easy with excel, but you could use sed, awk, and a few other command line tools (you have a Mac, right?) to write a script to do it. Dan -- Sent from an iPad. There should be less mispelings, but more errors. On May 8, 2012, at 8:12 PM, Patrick Wiggins <paw@wirelessbeehive.com> wrote:
Here's the way the file is produced:
http://users.wirelessbeehive.com/~paw/temp/excelchallenge.zip
Looks like it's going to be a long night of data-taking tonight (yea!) so I'll have lots of time to try out the various suggestions that have been made here today.
Thanks all!
patrick
On 08 May 2012, at 15:43, Patrick wrote:
Hi,
The original is a text file.
I'm converting it to Excel so I can use Excel's sort function since I don't think text files can be sorted.
I'll post a complete original file when I get home this evening for folks to play with.
Thanks to all for their help.
patrick
On 08 May 2012, at 14:12 , Chrismo wrote:
i guess i'm not understanding how the original data is formatted. is this stuff: SlewToObject, NGC 2314, 7.20284 75.30996 WaitFor , 5 , TakeImage , 30 ,
not in a spreadsheet to start off with?
_______________________________________________ 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".