sorry i inadvertently sent the previous message before i completed it. it had occurred to me that your data might have a comma and space before the #, addresses are often written that way. which would require a little tweaking of the formula, however on further reflection i am inclined to assume the accuracy of your description of the needs for the formula
in peace robert On Sun, Jan 18, 2009 at 11:53 AM, Robert Pollard <[email protected]>wrote: > malkie > > since sending the formula, i realize that i didn't think about - not did > you mention, whether your existing data has a comma and space preceding thin > coming > > > On Sun, Jan 18, 2009 at 11:50 AM, Robert Pollard <[email protected]>wrote: > >> 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
