Split the Address

janreddy · Post by **janreddy** » Mon Aug 24, 2009 12:26 pm

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

Sreenivasulu · Post by **Sreenivasulu** » Mon Aug 24, 2009 1:10 pm

The question is quite generic ?
Is it a question on how to build the logic or a question on datastage ?

Regards
Sreeni

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Aug 24, 2009 1:13 pm

....or Quality Stage

janreddy · Post by **janreddy** » Mon Aug 24, 2009 2:48 pm

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

chulett · Post by **chulett** » Mon Aug 24, 2009 3:38 pm

Field().