limitation in import
Joe Hirschman
joe at aljex.com
Wed Jul 20 07:52:03 PDT 2016
you can edit the file, in almost anything, and replace those characters
with "," then save a .csv and import that way
joe
On 7/20/2016 10:47 AM, Tim OBrien via Filepro-list wrote:
> I have a text file that I need to process with the separation character of '^'.
>
> It has over 300 columns and my test file has 95 lines.
> I use fp 5.01.13R4 on centos 5.4
> and the line to read the db.txt file is
> import ascii fff=/u/tob/db.txt r=^J f=\^
>
> I can generate a report to examine the fields but it appears that when a line is read into fff it will not fill each field even though I know there is data there.
> For example the first record is the header and has 322 columns yet fff(60) and thereafter contain || when I use debug to examine it. In fact, fff(59) is the first field to be truncated from " OtherInsuredGroupOrFecaNumber" to |OtherInsuredGr|.
> Yet when processing other records it will go as far as needed (say fff(275)).
>
> It seems like there is some limit on characters since the header has many characters in every field while the data lines have many empty fields.
> I have already tried a csv using word syntax with exactly the same results.
> I have also renamed variables in the prc.
> I have tried both rreport and dreport with same results.
>
> Perhaps I'll need to do some workaround.
> Thanks
> tob at b-e-s-t.com
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160720/4c454fd8/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
--
Joe Hirschman
Aljex Software
463 Union Avenue
Middlesex, NJ 08846
(732) 357-8700 ext 110
www.aljex.com
Aljex Signature
********************************************************************
This email and any files transmitted with it are
confidential and intended solely for the individual or
entity to whom they are addressed. If you receive this
email in error please destroy it immediately.
*********************************************************************
Aljex Confidential
*********************************************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160720/0756b7cf/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Aljex-logo-signature.jpg
Type: image/jpeg
Size: 44724 bytes
Desc: not available
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20160720/0756b7cf/attachment.jpg>
More information about the Filepro-list
mailing list