Quick backstory that helps explain what I'm trying to figure out how to do. Every week I download a report for my work that has the following info:
| Client ID | Client Name | Client Address |
My boss is wanting to add an additional column to the report that pulls the country out of the address. Normally this shouldn't be too hard, right? Well, I wish! Or if it is I sure as heck and way overthinking it. The issue is that the report is pulled from a database of clients that are worldwide and all of the addresses are slightly different in the way they're made up.
For example, an address from the US might be:
123 Random Road, Fakeville, New York, United States of America, 52525
OR
456 Fake St, Randomville, Penn., United States of America (the), 65856.
And then an address from Japan might look like:
9-4, 1-Naka, Nagiyo, Naga-ya, Nagoya, Aichi, Japan, 460-9530
So my first thought was that I could just use a =right or =left. Or something along those lines.
But then we have addresses from places like Columbia that are more like this: KM 8.5 BODEGA EN VENTA 80, Engativá, Bogota, Colombia.
So I have no idea where to even start for this. I tried to google and someone mentioned setting up an index, but I have no idea how to go about doing that or implementing it.
Any and all input would be amazing!!!
| Client ID | Client Name | Client Address |
My boss is wanting to add an additional column to the report that pulls the country out of the address. Normally this shouldn't be too hard, right? Well, I wish! Or if it is I sure as heck and way overthinking it. The issue is that the report is pulled from a database of clients that are worldwide and all of the addresses are slightly different in the way they're made up.
For example, an address from the US might be:
123 Random Road, Fakeville, New York, United States of America, 52525
OR
456 Fake St, Randomville, Penn., United States of America (the), 65856.
And then an address from Japan might look like:
9-4, 1-Naka, Nagiyo, Naga-ya, Nagoya, Aichi, Japan, 460-9530
So my first thought was that I could just use a =right or =left. Or something along those lines.
But then we have addresses from places like Columbia that are more like this: KM 8.5 BODEGA EN VENTA 80, Engativá, Bogota, Colombia.
So I have no idea where to even start for this. I tried to google and someone mentioned setting up an index, but I have no idea how to go about doing that or implementing it.
Any and all input would be amazing!!!