OT: OpenVMS question
Etienne Rompre
erompre at koala-tech.com
Fri Apr 13 08:07:28 CDT 2007
HI,
Just a suggestion...
If you work with different languages...ex: French and English, you
should use ; as the separating code since number in French use , as
decimal in number ex: 24,15$ VS . for English ex: 24.15$ or some people
place comma after the number in an address.
I had the issue here and standardized on ; since Excel will recognize it
as a separating value by default in a CSV file.
Just my 2 cents...
Etienne
> 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.
>>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> 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