Is there a way to extract the zip code only from an address string with inconsistent formatting? I would like to use the zip code as the geodata so I can show a map of the related customer data by zip code. Here’s an example of my shipping data. In the current format, the data is not recognized as an address format, It only:
sample company, OK 74501, USA.
123 sample road Dr, Edmond, OK 73034, USA.
456 sample Avenue, Deerfield Beach, FL 33442, USA.
123 sample Highway, Hollsopple, PA 15935, USA.
124 sample Lane, Colleyville, TX 76034, USA.
123345 sample Road, Suite123, Pineville, NC 28134, USA.