String pattern matching in lookup stage!!!
Posted: Thu Nov 20, 2008 12:15 am
Hi,
I have a requirement i am doing a lookup based on strign field and am suppose to use the contains logic to match.
Ex: If my source is "washington" and the value in the lookup is "washington DC USA", these records should match. Actually these are unmatched records.
But the requirement is that these should be matched similar to the string pattern matching using "like" in oracle.
How can I implement this requirement?
I already have a lookup stage where am looking up on the same fields mentioned above. if this requirement of mine can be implemented in the same lookup, it would be great.
I cannot take a substring of the data and do the lookup(Ex: Field[1,5]). Coz, if i restrict the data to certain length, i'll have duplicates from the lookup which would fetch me an invalid value.
Thanks in advance,
I have a requirement i am doing a lookup based on strign field and am suppose to use the contains logic to match.
Ex: If my source is "washington" and the value in the lookup is "washington DC USA", these records should match. Actually these are unmatched records.
But the requirement is that these should be matched similar to the string pattern matching using "like" in oracle.
How can I implement this requirement?
I already have a lookup stage where am looking up on the same fields mentioned above. if this requirement of mine can be implemented in the same lookup, it would be great.
I cannot take a substring of the data and do the lookup(Ex: Field[1,5]). Coz, if i restrict the data to certain length, i'll have duplicates from the lookup which would fetch me an invalid value.
Thanks in advance,