100 N Main St 3001 No W Rubick Ave && number=3001, st_prefix = No, Street=W Rubick, st_type = Ave 12 Sycamore Dairy Rd NW && number = 12, street=Sycamore Dairy, st_type=Rd, st_suffix = NW 1312 S Cain St E Suite A10 && number = 1313, st_prefix=S, street=Cain, st_type=St, st_suffix=E, apt_room=Suite A10 100 N Main St NW Ste 110 210 Jones Dr Apt 1E 8700 Smith RdParse the values typed above into these fields:
number c(10) && 100, 3001, 12, 1312, 100, 210, ... st_prefix c(10) && NW, S, E, NE... street c(30) && Main, Cain, ... st_type c(10) && Blvd, ST, AV, ... st_suffix c(10) && NW, S, E, NE, ... apt_room c(10) && Apt 102, Suite 109, etc...Anyone up to the task on a Friday?