OT: OpenVMS question
Lorry Litman
LLitman at exchange.hsc.mb.ca
Tue Apr 17 08:43:31 CDT 2007
Hi Darren,
Maybe this will work for you.
I created a little quiz that writes a number of rows to a vms file with 10 columns. No quotes around text and used "^" as my delimeter between strings. File extension to vms file was not ".csv" it was my name followed by date.
Opened excel 2003, off the "Data" drop down menu, chose "Import external data" and then chose "Import data". Specified location and name of file. Excel opened with the standard excel convert text-to-columns wizard. I changed the delimeter from the default "tab" to other: "^", clicked finish and there it was. I could then save the file as an ".xls" file.
Maybe you can change something on the quiz side that creates the file, or a dcl command procedure combined with an fdl file might help, or...
Lorry
-----Original Message-----
From: powerh-l-bounces+llitman=exchange.hsc.mb.ca at lists.sowder.com [mailto:powerh-l-bounces+llitman=exchange.hsc.mb.ca at lists.sowder.com] On Behalf Of Darren Reely
Sent: April 16, 2007 13:08
To: Powerhouse List
Subject: Re: OT: OpenVMS question
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.
>>>>
>>>>
>
>
>
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.
This e-mail and/or any documents in this transmission is intended for the address(s) only and may contain legally privileged or confidential information. Any unauthorized use, disclosure, distribution, copying or dissemination is strictly prohibited. If you receive this transmission in error, please notify the sender immediately and return the original.
More information about the powerh-l
mailing list