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: 12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4   13.5    Statistic    FMM    Blog  

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 )   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

This function checks for a license.

Created 11st December 2014, last changed 25th June 2019


List.AndColumn - List.CSVSplit

💬 Ask a question or report a problem