Handling Name with spl characters

rajan.n · Post by **rajan.n** » Mon Jul 14, 2008 1:17 pm

Hi All,

( I am very new to QualityStage )

Here I got a requirement :
The names are included with Mr. or Dr. and some of the names have the ending part as (Sp?) ( I dont know what this means but this need to be get removed )

For example : Ray Biactin (sp?)
: Ray (sp?)
: Mr. Ray Biactin
I need the first and last name to be seperated , in the second case Ray(sp?) only Ray need to be included.
I was trying to use Standerdize stage. Can any one sujjest how to resolve this.

Thanks Much in advance,
Rajan.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 3:31 pm

What does Word Investigation tell you this string generates as a pattern? Add a pattern override to discard the "(sp?)" piece.

The string "(sp?)" conventionally means "spelling doubtful".

rajan.n · Post by **rajan.n** » Mon Jul 14, 2008 6:56 pm

Hi Ray , Thanx for the reply.

I see that i need to override by using the following code
"OVERRIDE_D Lookup_Value @Table_Name Return_Code [ CLASS | VALUE ] "

can you please let me know indetail please (steps) , and where to create the table and do i have to use the investigate stage ?

Which document will help me to know the clear process so that i can look into some examples.

Thanks again Ray.

Rajan

ray.wurlod · Post by **ray.wurlod** » Mon Jul 14, 2008 7:21 pm

You don't have to script anything - use QualityStage designer to design your input pattern override.

You don't have to investigate - this step would, however, allow you to see what other patterns or text strings are in need of work. Typically you would, however, investigate the results of a standardization, especially the unhandled pattern field (C mask), adding X mask on unhandled data, original data fields, etc so that these too appear in the report, and increase the number of samples (examples) for each case to, say, five.

There is really only one manual you need, the QualityStage User Guide.

Don't start trying to use Pattern Action Language until you have had some experience with using the product "out of the box".

rajan.n · Post by **rajan.n** » Tue Jul 15, 2008 2:01 pm

Ray ,

I learnt that i need to use the standardise stage and with the multiple outputs which i get , i need to select the one or two coloums which are qualifying my requirement. Please correct me if am wrong.

regarding the mask C , or X - when am using the standardise stage where can i perform this on the unhandled data ? ( I see the unhandled data /pattern colums generated by the standardise stage- i could not find the C,T,X masking options in standardise stage)

ray.wurlod · Post by **ray.wurlod** » Tue Jul 15, 2008 4:03 pm

You need to run a Character Concatenate investigation on the unhandled pattern (C-mask), unhandled data (X-mask) and anything else you think would assist (X-mask). You do this after the standardization has been run.

rajan.n · Post by **rajan.n** » Tue Jul 15, 2008 4:13 pm

Thanks Ray,

Can you please clear me how this C-Mask and X-Mask will help me , with what stages and what all the stages I need to use here ?

Thanks again.

Rajan

ray.wurlod · Post by **ray.wurlod** » Tue Jul 15, 2008 4:37 pm

Investigate stage processing the output file from the Standardize stage.
C-mask gets the field analyzed (investigated) and included in the report.
X-mask gets the field included in the report without being analyzed.