limitation in import

tob at b-e-s-t.com tob at b-e-s-t.com
Wed Jul 20 07:47:05 PDT 2016


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>


More information about the Filepro-list mailing list