<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2523" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2> Filepro 5.0</FONT></DIV>
<DIV><FONT face=Arial size=2> Record is as
follows-</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>CLM*INV1191*175***11::1*Y*A*Y*A*B~</FONT></DIV>
<DIV><FONT face=Arial size=2>There is only one field in this record as
above </FONT></DIV>
<DIV><FONT face=Arial size=2> </FONT></DIV>
<DIV><FONT face=Arial size=2>INV1191 is the invoice # and can contain up to
8 numbers after the INV.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I use a mid string function as
follows:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>aa = mid(1,"8","8")</FONT></DIV>
<DIV><FONT face=Arial size=2>aa then equals 1191*175</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I then set ab(8,.0) = aa</FONT></DIV>
<DIV><FONT face=Arial size=2>I expected this to give and edit error but ab was
actually 1191. This works fine for my purposes but I was surprised
that it worked.</FONT></DIV>
<DIV><FONT face=Arial size=2>When I test the .0 edit I cannot enter 1191*175 as
expected, it only takes 1191. The fact that this works prevents looping or
using the instr function to extract the actual invoice number. Is this
expected behavoir? Is there a better way to extract the number from this
field - the number following the INV may be between one and eight
numbers. This works for any of these.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks in advance - Robert P.
Pulliam M.D.</FONT> </DIV></BODY></HTML>