OT: OpenVMS question
Joe Boyle
joeboyle_adt at hotmail.com
Thu Apr 12 16:37:00 CDT 2007
As Homer might say, Hmmmnnnn! As Etienne suggested, I suspect that so long
as the text file ( e.g. output from quiz) is either comma separated, or tab
( e.g. using the char function on a defined integer item holding whatever
the ascii code is for the tab char ) separated, and it is then renamed to
'.csv' ( where it may have been the PH quiz default of '.txt'), then excel
will read it correctly. I say this specifically because the comment
'properly qualified CSV file ' dos'nt seem relevant here; it is all about
the file extension, and appropriate choice of separater.
Pedant out :)
----- Original Message -----
From: "Johnson, Harold A EDUC:EX" <Harold.A.Johnson at gov.bc.ca>
To: "Joe Boyle" <atla38 at dsl.pipex.com>; "Powerhouse List"
<powerh-l at lists.sowder.com>
Sent: Thursday, April 12, 2007 7:45 PM
Subject: RE: OT: OpenVMS question
> Yes, a properly qualified CSV file will probably have to be the way we go.
>
> Thnx all
>
> -----Original Message-----
> From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
> Sent: Thu, April 12, 2007 10:28 AM
> To: Johnson, Harold A EDUC:EX; 'Powerhouse List'
> Subject: RE: OT: OpenVMS question
>
> I think Etienne is correct, so long as your separator is a comma or a tab
> char. Presumably, a utility would require you to specify the separator
> char that it is to use.
>
> -----Original Message-----
> From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
> [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf
> Of Johnson, Harold A EDUC:EX
> Sent: 12 April 2007 17:23
> To: Powerhouse List
> Subject: RE: OT: OpenVMS question
>
> Hahaha. I was interested to find out if a utility exists on OpenVMS that
> will convert a text (CSV) file directly into a XLS type file that can be
> opened up by Excel without any intermediate steps (ie. Eliminate potention
> users errors when importing/opening a CSV file in Excel). We currently
> have a utility that converts text files directly into PDF files, so I was
> hoping this wasn't too much of a stretch.
> I gather however, that this type of utility is not known by this
> distiquished group. :)
>
> Thnx
>
>
> -----Original Message-----
> From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
> Sent: Wed, April 11, 2007 5:51 PM
> To: 'Powerhouse List'
> Cc: 'Etienne Rompré'; Johnson, Harold A EDUC:EX
> Subject: RE: OT: OpenVMS question
>
> I suspect that I have some form of 'email tourette's syndrome', please
> feel free to email 'someone else' if you feel I am managing it well :)
>
>
> -----Original Message-----
> From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
> [mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf
> Of Darren Reely
> Sent: 12 April 2007 00:57
> To: Powerhouse List
> Cc: Etienne Rompré; Johnson,Harold A EDUC:EX
> Subject: Re: OT: OpenVMS question
>
> Etienne, good point, but Harold did not say of the file used comma
> separator values. The columns may be separated by spaces, or tabs, or some
> other custom value.
>
> Harold. Your question led me to believe you were looking for a generic
> utility that could handle differing delimiter values. Sorry, I have no
> answer for that.
>
> If you are using comma separated values, here is a good source of
> information. This particular link goes to the part of the page regarding
> Excel & leading zeros.
> http://www.creativyst.com/Doc/Articles/CSV/CSV01.htm#CSVAndExcel
>
> Darren
>
>
> Etienne Rompré wrote:
>> Hi,
>>
>> If you save the file with the .csv extension, Excel should open it
>> automaticaly.
>>
>> Cheers!
>>
>> Etienne
>>
>>> Anyone know if a utility exists to convert delimited text files on
>>> Vms to an Excel type format?
>>>
>>> Cheers
>>>
>>
>>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: "subscribe" in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: "unsubscribe <password>" in message body to
> powerh-l-request at lists.sowder.com
> http://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
>
More information about the powerh-l
mailing list