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.
5 Kent Street 3 A lindt Street 2/15 bold Street 9/34-36 carmen Road 12/5a sandford Street
Number |Street ---------------- 5 |Kent Street 3A |lindt Street 2/15 |bold Street 9/34-36 |carmen Road 12/5a |sandford Street