OT: OpenVMS question
Joe Boyle
atla38 at dsl.pipex.com
Sun Apr 15 16:04:38 CDT 2007
This is also achieved by creating a .bat file which contains the command
'start excel' and then associating this with a desktop icon; when clicked,
the DOS commands in the .bat file are executed on the client ( which by this
time has been ftp'd the excel file ( or additionally the details of a 2nd
.bat file which is to be run by the .bat file associated with the desktop
icon.
-----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
Joe Boyle
Sent: 15 April 2007 21:30
To: 'Etienne Rompr é'; 'Powerhouse List'
Subject: RE: OT: OpenVMS question
Hi,
I am using syntax as below, but if you do not have a cmd icon, then do as
follows,
1. click start
2. click run
3. type 'cmd' followed by return
4. use either of the commands below, but include the path to the file you
wish to open e.g.
'start excel c:\myexcel\filename.anyextent' with tab seps
'start excel c:\myexcel\filename.csv' with , seps for me - but ; seps for
you ?
'start excel filename.any'
The above works with the tab separator ( which I have happily used since
1995 ) regardless of the file extension.
'start excel filename.csv'
The above works with the , separator but only when the file extension is
renamed to .csv.
-----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
Etienne Rompr é
Sent: 15 April 2007 20:40
To: Joe Boyle; 'Darren Reely'; Powerhouse List
Subject: Re: OT: OpenVMS question
Hi,
I'm using the French version of Office in Macintosh or in PC environment and
I can use ; as a seperator in CSV file in both.
Are you opening the file on double cliking it or from the open menu in
Excel?
I had a case with Office 97 where the file must be opened from the Open menu
and Excel wouldn't recognize the ; if we would double click...
N.B. I just tried it on NeoOffice (Open Office for Mac OS X) and it worked.
Etienne
> I should add that I am using Excel 2003 on XP Pro SP2, and that I too am
not
> able to get the ; separator working, but I do not thing that Etienne's
claim
> is wrong - I suspect we simply have different setups or are using
different
> mechanisms to invioke Excel.
>
> My text examples are below,
>
> tab Sep'r
>
> a "=""0001,714.76""" "="" dasret,erfd """ end1
> a 6 sssssssss "=""0099,999.99""" end2
>
> , sep'r
>
> a,"=""0001,714.76""","="" dasret,erfd """,end1
> a 6,sssssssss,"=""0099,999.99""",end2
>
> ; sep'r
>
> a;"=""0001,714.76""";"="" dasret,erfd """;end1
> a 6;sssssssss;"=""0099,999.99""";end2
>
>
> -----Original Message-----
> From: Joe Boyle [mailto:atla38 at dsl.pipex.com]
> Sent: 15 April 2007 19:12
> To: 'Darren Reely'; 'Powerhouse List'
> Subject: RE: OT: OpenVMS question
>
> Ok, I should not have used the term suspicion, this is in fact my finding
-
> clearly your finding is different - neither of us are wrong.
>
> I should have mentioned my method for opening my files, which is I
'suspect'
> where our difference of opinion stems from, namely, via the DOS command
> below,
>
> 'start excel filename.any'
>
> The above works with the tab separator ( which I have happily used since
> 1995 ) regardless of the file extension.
>
> 'start excel filename.csv'
>
> The above works with the , separator but only when the file extension is
> renamed to .csv.
>
>
> -----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: 13 April 2007 18:46
> To: Powerhouse List
> Subject: Re: OT: OpenVMS question
>
> Your suspicion is wrong. At least for Excel 2000 (9.0.6926 SP-3).
>
> If it is all about he file extension, then think for a minute what the C
> in CSV stands for.
>
> Darren
>
> Joe Boyle wrote:
>> 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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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