DSXchange

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?

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

Is this a QualityStage question ?

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

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.

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.