Unix import of a DOS spreadsheet...

Mike Schwartz mschw at athenet.net
Fri Sep 3 19:36:02 PDT 2010


> Why not just run it through sed and kill end-of-line \r characters
> before
> imnport?
> 
> m->

         I can think of about 10 workarounds, including using xlate to
replace that last CR character or reading the file in with readline instead
on import.  However, I know that the 13&10 syntax is supposed to work and if
it does, that would be the simplest solution.  

	I do a lot of file importing and exporting work and have run into
this problem before.  I would just like to know if filePro still does
support this syntax or if it's something I'm doing wrong in using it.
Stuart Werner's filePro Developer's Reference, 4th edition, page 369,
indicates that this syntax should work. 

	I've tried r= 13 & 10, r=13&10, r=013&010 and several other options,
but I still get a syntax error.

	I've also tried putting the 2 characters inside a variable EL and
then using r=(EL).  There must be some way to get filePro to recognize an
end-of-record marker other than /n /t, etc.

Thanks,

Mike
   
      




More information about the Filepro-list mailing list