<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=546340803-16082004><FONT face="Courier New" color=#0000ff
size=4><STRONG>See my message to Mark... I did not see your message at first.
You can use the "autoshuf" program to do what you want... with some, well,
fairly sophisticated processing as well. You would import the fields from a
file... determine at that time how many fields would be needed in the
destination file, write them out directly to the map.temp file of that filePro
file with I/O functions and then issue the autoshuf command against that
file. Or, better yet, if there is NO data in that destination file (and
there probably wouldn't be...) just directly re-write the map to be what you
need. (i.e., add the fields, then modify the top line of the map file to reflect
the changes.) </STRONG></FONT></SPAN></DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4>However, there is one thing I don't understand. How are you importing the
fields into the current file if you don't already have "it" set up to have the
proper fields?? Or, are you trying to import the data into another file...
the destination file we are talking about?</FONT></STRONG></SPAN></DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4>Also, last thought, if the data is coming in various formats, assuming
they are structured somehow... could you just overlay an alien file against the
data-source file and do your work right there?</FONT></STRONG></SPAN></DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New" size=4>More
explanation would help... as to what exactly you are doing and wanting to
do.</FONT></STRONG></SPAN></DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New"
size=4></FONT></STRONG></SPAN> </DIV>
<DIV><SPAN class=546340803-16082004><STRONG><FONT face="Courier New" size=4>John
Esak</FONT></STRONG></SPAN></DIV>
<DIV><SPAN class=546340803-16082004> </SPAN></DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
filepro-list-bounces@lists.celestial.com
[mailto:filepro-list-bounces@lists.celestial.com]<B>On Behalf Of </B>John
Koenig<BR><B>Sent:</B> Sunday, August 15, 2004 8:17 PM<BR><B>To:</B> Filepro
List<BR><B>Subject:</B> Processing to add/create real fields in an existing
file <BR><BR></FONT></DIV>Filepro Experts:<BR><BR> I import files that
contain information regarding pools of mortgages, which I then analyze using
Filepro. <BR>These files do not have a uniform format as they are from various
mortgage lenders.<BR><BR>The processing that I have written requires that the
output be stored in <B><U>real field</B></U>s within the file that I have
imported. Therefore<BR>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.<BR><BR>Is there a simple way to
add real fields to a file via a filepro processing table (dos/windows
version)? <BR><BR>For example:<BR><BR>Say I have a mortgage file (named
"mortgage") with the following fields.<BR><BR>1)
MortgageAmount 10, $<BR>2)
Rate
6, F<BR>3)
Term
3,.0<BR>4)
ClosingDate
8,yymd<BR><BR>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 <U>mortgage </U>file itself since I always import the new<BR>data into
the same file for initial processing with the standard processing table I have
written.<BR><BR>5)
maturityDate
8,yymd<BR>6)
maturityMonth 3,*<BR><BR>My
thanks in advance for any help!<BR><BR>Regards,<BR><BR>John
Koenig<BR><BR><BR></BLOCKQUOTE></BODY></HTML>