import

[Bruce Easton]

> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com]On Behalf Of Jeff
> Harrison
> Sent: Tuesday, January 10, 2006 11:56 AM
> To: 'Filepro List'
> Subject: RE: import
>
>
> --- Kenneth Brody <kenbrody at bestweb.net> wrote:
>
> > Quoting Jeff Harrison (Tue, 10 Jan 2006 08:23:35
> > -0800 (PST)):
> >
> > > --- GCC Consulting <gccconsulting at comcast.net>
> > wrote:
> > >
> > > > CONVERT TO DBF, AND USE DBCOPY.
> > > >
> > > > THIS WILL AVOID THIS PROBLEM
> > >
> > > Yes, also creating an alien file will avoid the
> > > problem, also a tab delimited file...  Oh, and
> > > probably about 7,013 other ways. :-)
> >
> > Creating an alien file won't help in this case.
> > Although the fields
> > in each line are space-padded to a fixed length, the
> > final field on
> > each line has no such padding.  Therefore, the file
> > itself does not
> > have fixed-length records.
> >
> > --
>
> Ah, Yes, If it is not truely fixed length then the
> alien will of course not work.  Ok, we are down to
> just 7,014 ways now.
>
> Jeff Harrison
> jeffaharrison at yahoo.com
>
> Author of JHExport and JHImport.  The easiest and
> fastest ways to generate code for filePro exports and imports.
>

For that type of data, I usually use the tab-delimited export from Excel and
then on *nix, using vi remove any Ctrl-M's and quote marks with two ed
commands:

:g/^M/s/^M//g     (Ctrl-V,Ctrl-M to get the ^M) and
:g/\"/s/\"//g

prior to importing.

Bruce Easton
bruce at stn.com
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list