RE: CPYTOIMPF

Jim,
There is a free utility at
http://www.geocities.com/SiliconValley/Pines/5581/tips.htm called
CVTPFXLS that will convert your file to an excel sheet and save it to
the IFS. The only problem I have found with it is that it disables
logging.

HTH

Terry Anderson

 

> >
> >message: 8
> >date: Thu, 4 May 2006 09:51:26 -0500
> >from: jlowary@xxxxxxxxxxxxx
> >subject: CPYTOIMPF
> >
> >Is there a way to get the CPYTOIMPF to not put out a x'0A' 
> >at End-of-File? 
> > 
> >
> >I have a rather large file I'm copying to the IFS and user 
> >is opening it 
> >via Excel (I know shouldn't happen but it does) any way the 
> >file is big 
> >enough that we have to use a macro to load it into multiple 
> >sheets.  If 
> >the x'0A' is the file the macro locks up on first read (did 
> >a debug in VB 
> >to check it), but if I open this in WordPad and remove last Char 
> >(destructive backspace) then it opens fine??
> >
> >I don't see a way to tell the CPYTOIMPF command to not put 
> >x'0A' on the 
> >file (but might have over looked it).  If not would there be 
> >a way to copy 
> >the file can strip off the x'0A'?
> >
> >Thanks for any suggestions.
> >
> >Regards,
> >
> >-- Jim
> >