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
