Processing to add/create real fields in an existing file

Tony Ryder tryder at westnet.com.au
Sun Aug 15 19:12:21 PDT 2004


I would make a new file with all the required fields 1 - 6
and then create processing to import the data into a new record
from the mortgage file.

Tony Ryder

-----Original Message-----
From: John Koenig
Sent: Monday, 16 August 2004 10:17 AM

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



More information about the Filepro-list mailing list