RE: [HCDX]: Public Version of A99 HFCC schedule

[df@xxxxxxxxxx]

heh  Because the times are 4 character fields WITH leading zeros, WITHOUT
punctuation, as they should be.  Times without leading zeros and with
punctuation are too much of a pain to handle.  First, one has to remove the
punctuation.  Then one has to add the leading zeros.  

It's unfortunate that the creators of spreadsheet software (Excel,
Quatro-Pro, 1-2-3) are so ignorant that they do not provide the ability to
handle proper 24 hour time formats correctly.  

To incorporate into a spreadsheet, just parse the data as text and it
appears exactly as it should.  It then sorts correctly, too.  Note that the
files also correctly show program times ending at midnight as "2400", and
those beginning at midnight as "0000"


Unfortunately, the date fields have to be reordered to the more logical
yymmdd format to sort properly.

df

At 15:53 4/5/99 +0200, you wrote:
>> The public version of the A99
>> HFCC schedule is at http://itre.ncsu.edu/radio/hfcc/a99allx2.zip
>
>I've been playing around with that file.  Most interesting list.  But does
>anybody know why times are presented without a colon or a dot.  This is also
>the case in the Cumbre files and a lot of others.  This causes problems when
>importing those files into spreadsheets like excel or quattro pro.  During
>import it is not possible to tell the system that these figures are times
>and when changing the column properties  afterwards, all figures are changed
>to 00:00.
>
>Or is there a way to get around this, and am I overlooking something ?
>
>Maybe it is best to post answers directly to me.
>
>Guido.
>------------------------------------------------------------------------
>This is a message from "Guido Schotmans" <gs@xxxxxxxxxxxxxxxx>
>to hard-core-dx@xxxxxxxxxxxxx list. To unsubscribe the list, send
>"unsubscribe hard-core-dx" in mail body to majordomo@xxxxxxxxxxxxxx
>For more information, please check http://www.kotalampi.com/hard-core-dx/
>or email Risto Kotalampi, risto@xxxxxxxxxxxxxx
>------------------------------------------------------------------------
>
>
------------------------------------------------------------------------
This is a message from df@xxxxxxxxxx
to hard-core-dx@xxxxxxxxxxxxx list. To unsubscribe the list, send
"unsubscribe hard-core-dx" in mail body to majordomo@xxxxxxxxxxxxxx
For more information, please check http://www.kotalampi.com/hard-core-dx/
or email Risto Kotalampi, risto@xxxxxxxxxxxxxx
------------------------------------------------------------------------