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
