Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
9.3
9.4
9.5
10.0
10.1
10.2
10.3
10.4
10.5
10.6
Statistic
FMM
Blog
List.BestMatch
Looks for best match of a text in a list of texts.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| List | 5.0 | Yes | Yes | Yes | Yes | Yes |
MBS( "List.BestMatch"; List; SearchText ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| List | The list to process. | "Hello" ¶ "" ¶ "World" |
| SearchText | The text to search. | "Hello" |
Result
Returns best match, empty or error.
Description
Looks for best match of a text in a list of texts.If not found, returns empty result, so FileMaker function isEmpty() will tell you if it's empty (instead of just having no text).
Uses internally the Text.LevenshteinDistance function to compare all items and look for best match.
If no entry matches over 50%, this may return empty text.
See also QuickList.BestMatch in case you need to query several times and want to load list only once.
Examples
Looking for best match for Hilo will find Hello:
MBS( "List.BestMatch"; "Test¶Hello¶World¶Hallo"; "Hilo" )
See also
Blog Entries
Created 11st December 2014, last changed 25th June 2019
List.AndColumn - List.CSVSplit
Feedback: Report problem or ask question.
Links
MBS FileMaker Plugins
