regexpr and matching strings

mabl4367

I'm making a report that lists all possible contact doubles.

It compares all contacts to all contacts except comparing a contact to iteslf.

When comparing fields like VAT-No. an exact comparison is prefered but when comparing contact names I would like a more relaxed comparison.

I hav made a function that matches to strings by finding the longest substring that occurs in both strings compared and returns the length of that substring devided by the length of the longest string compared.

However this will not be a good indicator if the two strings compared are the same except for one character in the middle of the strings.

How can I solve this problem?

It would be nice to have a solution that is not so compute intensive since all contacts compared to all contacts is a lot of work!

Luc_VanDyck

Are you aware that this is standard functionality in the CRM module of NAV?
Sales & Marketing -> Marketing -> Periodic Activities -> Duplicates

mabl4367

Yes I am aware of that now My colegue just pointed it out to me.

I'm still curious though. How do I match strings?

mabl4367

Ofcourse I'm not the first person to face the problem of measuring the difference between to collections of objects.

This link provides some intresting reading on the topic:
http://en.wikipedia.org/wiki/Diff