OT: OpenVMS question
Joe Boyle
atla38 at dsl.pipex.com
Sun Apr 15 13:19:14 CDT 2007
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.
More information about the powerh-l
mailing list