OT: OpenVMS question

[Johnson, Harold A EDUC:EX]

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.