Fuzzy Matching

[Former Member]

Hi All

I have a data cleansing requirement to merge names that are similar. Currently this is done by a user manually and I need to automate it.eg Smith, Smyth, LSmith, and other typing erros should all be just Smith

Are there any functions or technique that can be used in a transformation to achieve this.

Regards

Asif

[dennis_scoville4]

In this forum stream, there is code using SOUNDEX that you might want to give a try. It also mentions that this could be solved through using TREX, if you have that installed (doesn't explain how though).

[]

[FCI]

There use to be a STRING_COMPARE_FUZZY function module in SAP that disapears in earlier version (you still find some oss note with a trace of it). I assume that we are now compelled to develop our own...

Good luck

Regards,

Fred

[Former Member]

Hi,

I do not think there is any function for this, probably you can write routine of your own either in start routine or update routine.

Regards,

Kams