Page 1 of 1
Split the Address
Posted: Mon Aug 24, 2009 12:26 pm
by janreddy
Hi I would like to extract the house number and Street from Address field so I am wondering how to do it in DataStage.
Thanks
Jana
Posted: Mon Aug 24, 2009 1:10 pm
by Sreenivasulu
The question is quite generic ?
Is it a question on how to build the logic or a question on datastage ?
Regards
Sreeni
Posted: Mon Aug 24, 2009 1:13 pm
by Sainath.Srinivasan
....or Quality Stage
Posted: Mon Aug 24, 2009 2:48 pm
by janreddy
I have one source field: Address_Line = 5353 Windward Pkwy so I would like to split this into two fields: House number = 5353 and Street = Windward Pkwy so do we have any function in DataStage to achieve this.
Thanks
Jana
Posted: Mon Aug 24, 2009 3:38 pm
by chulett
Field().