Address Parsing using Oracle
Hello Oracle Experts
I need help in seperating the numeric and alpha parts in the street name of the address as shown below.
My Oracle Version is
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Please help me in parsing the same.
5811WIPPRECHTAPT3
25742SE31STPL
2834TALLOAKTRAIL
1500SE14THST
The output I am expecting is
5811 W IPPRECHT APT 3
25742 SE 31ST PL
2834 TALLOAK TRAIL
1500 SE 14TH ST
If Number is suffixed by TH then no parsing is required as example 4.
I would appreciate any lead in this matter.
regards
Rajesh