OT: OpenVMS question

[Joe Boyle]

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.