| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
List.BestMatch
Looks for best match of a text in a list of texts.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| List | 5.0 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "List.BestMatch"; List; SearchText { ; Flags } ) More
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| List | The list to process. | "Hello" ¶ "" ¶ "World" | |
| SearchText | The text to search. | "Hello" | |
| Flags | Available in MBS FileMaker Plugin 14.0 or newer. Pass 0 to use Levenshtein distance. Pass 1 to use Jaro-Winkler distance. Add 2 to return list of top 5 entries. |
0 | Optional |
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
Release notes
- Version 14.0
- Added flags for List.BestMatch and QuickList.BestMatch to use Jaro-Winkler distance optionally and optionally return list of top 5.
Blog Entries
- MBS FileMaker Plugin, version 13.6pr1
- MBS FileMaker Plugin debugging help
- MBS Filemaker Plugin, version 4.5pr4
This function checks for a license.
Created 11st December 2014, last changed 10th November 2023
