‎2011 Nov 05 10:07 AM
Hi All,
Could anybody tell , how do you find address detail by name based on threshold (%) criteria setting.
Case1: if you want to search address for name ; Angelica and threshold is set 99% and match case = 100%.
Then in the above case all address should come by name Angelica as mentioned below.
Angelica %0 salt lake U.s.
Case 2;: if threshold is set 30 and match case is 50%
then address should come base on Ange for Angelica
Ange 40 salt lake U.S.
Angelica 50 saltlake u.s.
angel jones 60 saltlake street u.s.
so anybody can suggest what are the steps require to solve above issue.
Regards,
alok
‎2011 Nov 05 10:20 AM
The problem is in your formulae.
Coz for 99% it is showing next ..
i.e 0..
and for 30 ..
it is showing 40 , then 50 , then 60.
Reward if find it useful.
Gaur Mayank
‎2011 Nov 05 5:30 PM
HI,
Actually you could not understand my question so please go through again the question and then give reply.