Niet32 Posted August 4, 2006 Share Posted August 4, 2006 Is it possible to set up a formulas to recognizie a word if it matches a certain percent of another word in a seperate field? For example: Field 1 Richmond, VA/Field 2 Rchmd VA If you put a parameter that said if Field 2 > 80% of Field 1 then use Field 1. Is this possible or have I been watching way too much Sci-Fi? Link to comment Share on other sites More sharing options...
comment Posted August 4, 2006 Share Posted August 4, 2006 It is somewhat possible - but you need to specify your need much more precisely. Not in Filemaker terms, but in semantic terms. Read this thread to get some idea of what's involved. Link to comment Share on other sites More sharing options...
Raybaudi Posted August 4, 2006 Share Posted August 4, 2006 That said, and if I understand you correctly, you can try this calculation: Let([ flt1 = Filter ( field1 ; field2 ); flt2 = Filter ( field2 ; field1 ); len1 = Length ( field1 ); len2 = Length ( flt1 ) ]; Case( len2 ≥ 65/100 * len1 and Exact ( flt1; flt2 ); field1; field2 ) ) Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6474 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now