Forum Discussion
Solved
String/Text search for keywords in multiple columns
Hello I have linked two datasources where I need to compare address fields for a match. I'm having trouble comparing the address columns for a match as the string in each column is not a dir...
This could be a starting point:
I've highlighted the problem area: "Ln" doesn't match with "Lane" so you have to decide how to deal with this: Either create a list of abbreviations that will be deleted in ColumnA before the match, cut off the last word from ColumnA or other strategies.
ImkeF
Community Champion
Community ChampionThis could be a starting point:
I've highlighted the problem area: "Ln" doesn't match with "Lane" so you have to decide how to deal with this: Either create a list of abbreviations that will be deleted in ColumnA before the match, cut off the last word from ColumnA or other strategies.