Is there a way to left trim including the building and number? Building 3 21-1 Great Avenue, a city, a country, this planet.
How to take way those things which are too local to an address? Regards, Shao On Sat, 25 Apr 2020 at 01:48, Shaozhong SHI <[email protected]> wrote: > I find this is a simple, but important question. > > How best to split numbers and the rest of address? > > For instance, one tricky one is as follows: > > 21-1 Great Avenue, a city, a country, this planet > > How to turn this into the following: > > column 1, column 2 > > 21-1 Great Avenue, a city, a country, this planet > > Note: there is a hyphen in 21-1 > > Any clue? > > Regards, > > Shao >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
