Removing a word from the name

Infosphere's Quality Product

Moderators: chulett, rschirm

Post Reply
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Removing a word from the name

Post by sendmkpk »

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
Posts: 3
Joined: Thu Feb 02, 2012 1:42 am
Location: no

Re: Removing a word from the name

Post by umaisnazir »

Use field function. Even sub-string will do the job.
Thanks and Regards,
Umais
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Post by sendmkpk »

well then i shall say, i want to do it only by input text override
Praveen
stuartjvnorton
Participant
Posts: 527
Joined: Thu Apr 19, 2007 1:25 am
Location: Melbourne

Post by stuartjvnorton »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Continuing that theme, you could also parse it into the AdditionalName field.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Post by sendmkpk »

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
rjdickson
Participant
Posts: 378
Joined: Mon Jun 16, 2003 5:28 am
Location: Chicago, USA
Contact:

Post by rjdickson »

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
Post Reply