Getting number in string and text after number(Challenge)
Hi,
I have varchar2 column which contain customer address in format
address space house_number space house extension
address=alphabatic chracters
house number =numeric
house extension =alphabatic chracters+number or null
I have to get these values and store in seperate fields and house_number is null or house_extension is null return nothing.
I have tried everything but failed.
example is
Förenta Staterna 7 X1
thanks,
7Z