Remove the Numeric from US Name Standardization rule set

[BuddingDev]

Hello,

I have given a requirement to remove any numeric coming into First name or last name field to standardize individual's name. Right now numeric are being populated in these fields. Such as Pa12ul, Newman will be standardize as Pa12ul,Newman

I am using USNAME rule set in Quality Stage for standardization.

Any kind of inputs will be much appreciated.

[rjdickson]

What version of QualityStage?

[ray.wurlod]

Given that it's version 8.x, I'd simply use a Transformer stage upstream of the Standardization stage.

Beware, however, that there are some strange individuals out there who insist on the numeric (for example "HEN3RY" is "Henry with a silent three"). They're more likely to be found in the UK than the US, and typically are protesting about this very kind of business rule!

Our problem is that they have made a legal name change (by "deed poll" in the UK) so that we have to be able to process them correctly. Typically this will use an exception table of some kind.

[BuddingDev]

Thanks!

I kept the logic in transformer which removed the numeric as you suggested.

With this I will mark it as resolved.
...