Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Im having some address data trouble. I have a number of agencys whos address I know and want to map.
The issue is the data quality of the entered Address is poor so to find out what address it actually is I need to best fit to my list to the datas list to categorise it.
I need like a fuzzy match or something , any ideas?
Thanks
Hello
Do you need find some addres? I dont understande very well, but if you need some function to find some data you can takea look at the match() or wildmatch() function, I don't know if this can help you.
Wildmatch
Match
For simple fuzzy matching, you could use something like this:
LOAD
dirtyAddress,
KeepChar(lower(dirtyAddress,'abcdefghijklmnopqrstuvwxyz01234567890)) as matchAddress,
Now matchAddress will match regardless of casing and punctuation.
For more complex matching you might need to find (or make your own) extension that calculates the difference (such as the Levenshtein distance between the strings).