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?
Replacing a substring with another using a Lookup
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.