0 - 2 of 2 tags for split column

Hi,  I need your help about an issue I have with a column that comes from the source like this:

Size

5

6

1 LB

1.1 LB

10 LB

10LB

10LBS

15 LB

16 OZ

17 LB

2 LB

Hi teradata Guru's;
I'm new to teradata. can some one tell me that how can i split address column into multiple columns??
eg
s_id                                   address
1                                       house # 1 street # 1 (some more information) City_name
 
i actually want to split it ....
e.g