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