Re: [Utah-astronomy] Excel challenge

Top Page
Delete this message
Reply to this message
Author: Daniel Holmes
Date:  
To: Utah Astronomy
Subject: Re: [Utah-astronomy] Excel challenge
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@???> 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@???
>
> 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".