Processing to add/create real fields in an existing file

John Koenig gineok7 at earthlink.net
Sun Aug 15 17:17:05 PDT 2004


Filepro Experts:

  I import files that contain information regarding pools of mortgages, 
which I then analyze using Filepro.
These files do not have a uniform format as they are from various mortgage 
lenders.

The processing that I have written requires that the output be stored in 
real fields within the file that I have imported. Therefore
declaring values will not work. At least I don't see how it would solve my 
problem. As a consequence after importing a file I find myself MANUALLY 
entering these fields time (various date fields such date next interest 
change etc) again and again.

Is there a simple way to add  real fields to a file via a filepro 
processing table (dos/windows version)?

For example:

Say I have a mortgage file (named "mortgage") with the following fields.

1)  MortgageAmount   10, $
2)  Rate                       6, F
3)  Term                       3,.0
4)   ClosingDate             8,yymd

I would like to write a filepro process (dos version)  that would 
automatically add the following fields to the map so that I can calculated 
the maturity date and store it in the file. The process can reside in the 
mortgage file itself since I always import the new
data into the same file for initial processing with the standard processing 
table I have written.

5)   maturityDate            8,yymd
6)   maturityMonth         3,*

My thanks in advance for any help!

Regards,

John Koenig


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.celestial.com/pipermail/filepro-list/attachments/20040815/a3b5181a/attachment.html


More information about the Filepro-list mailing list