Count differences beetwen 2 fileds? - 01-13-2006 , 11:38 AM
Is there a way to count differences beetwen 2 fileds with FMPA 8v2 ?
test 1 :
FIELD_1 = "TABLE"
FILED_2 = "TOBLE"
RESULT = 1
(A and O)
test 2 :
FIELD_1 = "BLUE COW"
FILED_2 = "BLOW CUW"
RESULT = 3
(U and O, E and W, O and U)
Thaks for your help!
Re: Count differences beetwen 2 fileds? - 01-13-2006 , 03:36 PM
In article <43c7e591$0$31961$636a55ce (AT) news (DOT) free.fr>, fsdf (AT) fdsfdfds (DOT) com
length(u) = 0, length(v),
length(v) = 0, length(u),
(left(u,1) = left(v,1)) +
I haven't tested it but it should work. You'll need to tweak it a bit if
you want it to count a and A as "different" -- simply replace the
equality test with the Exact() function.