import

Kenneth Brody kenbrody at bestweb.net
Mon Jan 9 14:23:56 PST 2006


Quoting Steven Waters (Mon, 9 Jan 2006 13:58:31 -0800):

> I tried this one and got syntax error.
>
> >Alternately, if your file has a record separator character such as a
> New
> Line you could >use something like the following:
> >@menu:::
> >loop:::
> >::import ascii imp = /f/appl/fpmerge/tgicaps.txt r=\n:
> >:not imp:goto endit:
> >::xx=imp(1):
> >::'  manually parse out fields from xx and write them to another file:
> >::goto loop:
>
> So I had to add
> import ascii imp = /f/appl/fpmerge/tgicaps.txt r=\n f=\n
> The result was field 1 importing. The other fields dropped off.
>
> I'm off to try the Alien file suggestion.

If this really is not a delimited file, then you can't use IMPORT,
as that requires field and record delimiters.  In that case, using
an alien file is probably the best way to go.

However, if it is a delimited file (and most ".txt" files are not
fixed-length non-delimited files), then all you need to do is find
out the correct field and record delimeters.

Perhaps if you were to post the first part of the file, for us to
see the actual contents?

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


More information about the Filepro-list mailing list