DSXchange

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

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

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

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.

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

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

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.