Page 1 of 1

Non Human Name Filtering

Posted: Tue Mar 06, 2007 4:33 pm
by memrinal
Hi,
Please let me know, how to achieve the following, using QualityStage:
Filter all the records which dont have human names in First and Last Name Fields, like Ending in Co. , Ltd, M/s stc.

Please Let me know how this can be implemented in QS.
Currently a perl script has a list of strings, against which it compares the name fields and filters records as required.

Thanks in Advance

Posted: Tue Mar 06, 2007 5:03 pm
by ray.wurlod
If you standardize using a xxNAME Rule Set, names are identified as individual or organizational (I or O) in the Name Type (NTxxNAM) column.

If you want something more graceful, then you might consider some Pattern Action Language to effect a comparison against the name classification table (xxNAME.CLS) in which known first names are identified.
Last names are much tricker - potentially any word can be a last name. That said, however, any word marked as other than "F" or 'I" in the name classification table is a probable candidate for your requirement.

Posted: Tue Mar 06, 2007 5:04 pm
by us1aslam1us
I am not pretty sure about this but try using SELECT stage and under the Accept action define the rule something like " First Name = Co. or First Name= Inc". I have never used but you can try it.