OT: OpenVMS question
Etienne Rompr é
erompre at koala-tech.com
Sun Apr 15 14:40:21 CDT 2007
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.
>>>
>>
More information about the powerh-l
mailing list