<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>you can edit the file, in almost anything, and replace those
characters with "," then save a .csv and import that way</p>
<p>joe<br>
</p>
<br>
<div class="moz-cite-prefix">On 7/20/2016 10:47 AM, Tim OBrien via
Filepro-list wrote:<br>
</div>
<blockquote cite="mid:1469026025.317210483@apps.rackspace.com"
type="cite">
<pre wrap="">
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
<a class="moz-txt-link-abbreviated" href="mailto:tob@b-e-s-t.com">tob@b-e-s-t.com</a>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20160720/4c454fd8/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20160720/4c454fd8/attachment.html></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Joe Hirschman<br>
Aljex Software<br>
463 Union Avenue<br>
Middlesex, NJ 08846<br>
(732) 357-8700 ext 110<br>
<a class="moz-txt-link-abbreviated" href="http://www.aljex.com">www.aljex.com</a><br>
<br>
<img src="cid:part1.2658EECD.0C2B7C59@aljex.com" alt="Aljex
Signature" width="140"> <br>
<br>
********************************************************************<br>
This email and any files transmitted with it are<br>
confidential and intended solely for the individual or<br>
entity to whom they are addressed. If you receive this<br>
email in error please destroy it immediately.<br>
*********************************************************************<br>
Aljex Confidential<br>
*********************************************************************<br>
<br>
</div>
</body>
</html>