How do I parse Address into Street Number, Name, Type, Unit Number? Is there a function which will conduct this?

2280 MEYERS AVE                                            
ALDERGROVE AVE & S VINEWOOD ST                             
412 E WASHINGTON AVE #3                                                               
AVOCADO AVE & LEMON ST                                     
572 N TULIP ST                                             
1030 HAWAII PL                                             
500 N MIDWAY DR A-E, ADMIN                    
  • would adding a select + work for your process? – Ali Razeghi Mar 18 '19 at 18:33
  • This might helpful: stackoverflow.com/questions/22250683/… – CR241 Mar 18 '19 at 18:37
  • Parsing an address is even more cumbersome than parsing a name. You need a list of unit designations, directional abbreviations, logic for order, etc. Is "10B Smith Street" the same as "10 Smith Street Apt B"? (normally, yes) See stackoverflow.com/questions/11160192/… for a very lengthy breakdown. – BlueGI Mar 18 '19 at 18:55
  • And hope that your only dealing with one set of legal bodies. Because if your dealing with international or unique standards it can be very lengthy. Hint: it’s partly why many online forms require the Country first before the other details are entered. – clifton_h Mar 19 '19 at 0:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy