malkie here is one way that might work, although there may be simpler ones
if contains[P1F7;"#"] then substring[P1F7; length[substring[P1F7]]+2; length[subfield[P1F7;"#";1]] - length[substring[P1F7]] -2] else substring[P1F7; length[substring[P1F7]]+2; length[P1F7] - length[substring[P1F7]] -2] endif hth robert On Sun, Jan 18, 2009 at 7:21 AM, <[email protected]> wrote: > I would like to divide an address field of 50 characters into 3 > (a) house number; (b) apartment number; (c) everything in between > > (a) field has the formula: subfield[P1F7;' ';1] > (b) field has the formula: If contains[P1F7;"*#*"] then > "#"subfield[P1F7;"#";2] else " " endif > What's the formula for (c) field? > > Malkie > > _______________________________________________ > Dataperf mailing list > [email protected] > http://lists.dataperfect.nl/mailman/listinfo/dataperf >
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
