Parse address field

Question

Hi,

I have a file which includes address column as seen below. I need to parse it into different components as street address, city etc. I am not very familiar with regex and need some help with it. Any inputs on this would be of great help. Thank you in advance!

Input

Address

8427 Old Bingham Hwy Ste. A  West Jordan Utah UT US

10 Elyise Rd Suite L4  Monsey New York NY US

3525 Del Mar Heights Rd Ste 812  san diego California CA US

Output

Street Address                                                City                                State                    Country

8427 Old Bingham Hwy Ste. A                          West Jordan                   UT                         US

10 Elyise Rd Suite L4                                        Monsey                           NY                        US

3525 Del Mar Heights Rd Ste 812                     san diego                        CA                        US

aparna0208 · Answer

@PhilipMannering wow this looks awesome and I learnt something new:) I tried running your workflow but it errored out. As you said probably I need to get a key. Not sure if this includes cost and any other complex thing so trying to figure out from the link you provided.

philipmannering · Answer

Hi @aparna0208

You could try using the Google Maps Platform api: https://developers.google.com/maps/documentation/geocoding/requests-geocoding

You'll need to get your own key. But you can make a certain number of requests free and I don't think you'll get better accuracy than Google maps. See workflow attached.

Google Maps Platform_nokey.yxmd

aparna0208 · Answer

@DataNath Thank you for your inputs. This helps to some extent. But yes, as you said trying to see if there is a dynamic or some other way to parse out street address without having to do it manually