Hi, I have a current phone variable which has mixed text with the phone numbers. I would like to create a new phone variable that just had the phone numbers. Secondly I would like all mobile numbers beginning with (4 or 04) to All begin with 04. And numbers beginning with 08 or 8 or 9 with a state = WA to All begin 08. and so on for all states. CURRENT PHONE STATE 0418448841MOBILE WA FAX90227506 WA CAR0L'S MOBILE 0409211082 WA 890213600 WA 90214178 WA 427866574 WA (HOME90930658) NSW 418934400 WA 0439394323/DESMOND WA thanks Sally
... View more
