Split string into two column
930602Apr 13 2012 — edited Apr 26 2012Hi Guys
I wonder if any one can help me, I a bit of a noob. I need to split to a string from one table and split into two columns in another table. There is a few different variety of numbers and rules but no clear delimiter. I was how this can be done. Do I use combo of SUBSTR and INSTR or use if then loops to satisfy all the rules.
Thanks in advance.
Table
5 Kent Street
3 A lindt Street
2/15 bold Street
9/34-36 carmen Road
12/5a sandford Street
Result
--------------------------------
Number | Street
--------------------------------
5 | Kent Street
3A | lindt Street
2/15 | bold Street
9/34-36 | carmen Road
12/5a | sandford Street