OT: OpenVMS question
Darren Reely
darren.reely at latticesemi.com
Mon Apr 16 13:07:41 CDT 2007
Well this is a mystery.
I've tried both methods described by Etienne and Joe and neither work
for me with either tab or semi-colon delimited files. I can say that I
personally have not done any customization to my copy of Excel. I can't
speak for the ops person who installed it.
Joe. Seriously. How many users are going to use the command line. Most
users don't have a clue that it even exists.
Anyway, I'm done with this. I don't have the time to fiddle further.
I'll be curious to see if an answer appears.
Darren.
Etienne Rompré wrote:
> 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