Replacing a substring with another using a Lookup

divstands · Post by **divstands** » Mon Aug 03, 2009 9:30 pm

I want to perfrom the following task:

Replace the a list of strings with oher defined strings for each(in the list) if they occur and wherever they occur in a given string.

For example

List:
Pedro Tom
Loc Localidad
San Man
Col Colonia

Hence the string
Loc San Pedro Arriba La Rosa Del CoL de Calle
should become
Localidad Man Tom La Rosa Del Colonia de Calle

Is this possible by a lookup table?

ray.wurlod · Post by **ray.wurlod** » Tue Aug 04, 2009 12:18 am

Not solely by a lookup table, but certainly by a lookup table followed by upstream pivoting and downstream processing (including vertical pivot).

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Aug 04, 2009 1:41 am

Is this a QualityStage question ?

Because qualitystage has different reference files which are used for tokens.

divstands · Post by **divstands** » Tue Aug 04, 2009 4:40 pm

Sainath.Srinivasan wrote:Is this a QualityStage question ?

Because qualitystage has different reference files which are used for tokens. ...

You are mentioning about the lookup tables of standardization rulesets.

But otherwise too, QS has the ability to create and utilize Lookup tables.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 04, 2009 5:08 pm

Good point, but the same story is true whether you're using a Lookup stage or a Standardization stage - you need to include all partial forms in the lookup/classification table.