import

[Kenneth Brody]

Quoting Steven Waters (Tue, 10 Jan 2006 06:45:39 -0800):

>
>
> Quoting Jeff Harrison (Mon, 9 Jan 2006 14:34:03 -0800 (PST)):
> [...]
> > Sorry, I thought that I had done that in the past, but I guess I was
> > confusing it with export ascii.  At any rate you should be able to
> > specify "r=\n f=~" (or something else for the field separator that you
> > know is not in the data)
>
> I believe that "f=255" works "best" for this.
>
>
> I did f=255 and still only get the first record imported.
> Is there a way to tell excel when saving as csv not to use commas
> but to use "~"? Or when in the txt file add the ~ separator?
> Here is one line of my data. I am still trying the alien file
> suggestion.
>
> 30210                        300 Cu-in. Brake Sys Accumulator
> 32     32-40-01   Landing Gear
> 737
> EFS Aerospace, Inc.

If it's really CSV, then why not simply tell filePro "f=, r=\n"?

The line you posted, however, is not CSV.  (And the spacing and
line wraps are probably being mangled by e-mail.)  How is this file
being created?

--
KenBrody at BestWeb dot net        spamtrap: <g8ymh8uf001 at sneakemail.com>
http://www.hvcomputer.com
http://www.fileProPlus.com