DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
sendmkpk



Group memberships:
Premium Members

Joined: 02 Apr 2007
Posts: 97

Points: 942

Post Posted: Wed Sep 25, 2013 4:35 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
HI,

I tried removing "ESTATE" from name "ESTATE OF ROY BURNER" after name standardization, using input text override.

The whole name is getting replaced with null instead,

I tried all the ways i could,

Can anyone suggest the proper way to do it

_________________
Praveen
umaisnazir
Participant



Joined: 02 Feb 2012
Posts: 3
Location: no
Points: 10

Post Posted: Wed Sep 25, 2013 5:40 am Reply with quote    Back to top    

Use field function. Even sub-string will do the job.

_________________
Thanks and Regards,
Umais
Rate this response:  
Not yet rated
sendmkpk



Group memberships:
Premium Members

Joined: 02 Apr 2007
Posts: 97

Points: 942

Post Posted: Wed Sep 25, 2013 6:52 am Reply with quote    Back to top    

well then i shall say, i want to do it only by input text override

_________________
Praveen
Rate this response:  
Not yet rated
stuartjvnorton
Participant



Joined: 19 Apr 2007
Posts: 518
Location: Melbourne
Points: 3853

Post Posted: Wed Sep 25, 2013 7:19 am Reply with quote    Back to top    

Why not do something useful with it, instead of just blowing it away?
At the very least, it tells you that it's not actually a person, but a legal construct now that the person is dead.

Classify it and put it in the additional information field. Then you can pick it out afterwards.
Otherwise, you could create a flag for it, and look for ESTATE and other terms like DECEASED, etc to set it.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Wed Sep 25, 2013 12:34 pm Reply with quote    Back to top    

Continuing that theme, you could also parse it into the AdditionalName field.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
sendmkpk



Group memberships:
Premium Members

Joined: 02 Apr 2007
Posts: 97

Points: 942

Post Posted: Wed Sep 25, 2013 11:53 pm Reply with quote    Back to top    

Well i was trying to play around with the text override.....

I knew it can be in trnsf stage, and also knew what the name referred to..

thx

_________________
Praveen
Rate this response:  
Not yet rated
rjdickson
Participant



Joined: 16 Jun 2003
Posts: 378
Location: Chicago, USA
Points: 2531

Post Posted: Mon Sep 30, 2013 10:31 am Reply with quote    Back to top    

Input text overrides are meant to handle the entire input, not portions of the input. That is why they are not working.

The best course is to do as Stuart and Ray suggested.

_________________
Regards,
Robert
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours