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

Reply via email to