Monkeybread Software - MBS FileMaker Plugin: Component: List

Components	All	New	MacOS		Windows		Linux		iOS
Examples	Mac & Win		Server	Client	Guides	Statistic	FMM	Blog	Deprecated	Old

Component: List

Text functions for working with lists.

For big lists, our QuickList functions are much faster.
Because the list is only parsed once and stored indexed in memory.

Version	macOS	Windows	Linux	Server	iOS SDK
4.2 / 14.3	✅ Yes	✅ Yes	✅ Yes	✅ Yes	✅ Yes

Item	Details
List.AddPostfix Adds a postfix text to each entry in the list.	All 6.1
List.AddPrefix Adds a prefix text to each entry in the list.	All 6.1
List.AddValue Adds a value to the list.	All 7.1
List.And Returns a list with values which are contained in both lists.	All 4.4
List.AndColumn Returns a list with values which are contained in both lists.	All 10.0
List.BestMatch Looks for best match of a text in a list of texts.	All 5.0
List.CSVSplit Splits CSV text.	All 7.4
List.CountValues Counts values in list.	All 8.1
List.CountValuesMatching Count matching entries in list.	All 10.2
List.CrossProduct Creates the cross product from two lists.	All 6.1
List.DeCombine Picks elements from each line in a list.	All 6.3
List.Deserialize Restores a serialized list.	All 5.2
List.Find Finds an entry in the list.	All 11.1
List.FindDuplicateItems Finds duplicate items in the list.	All 10.5
List.FindEquals Finds equal items in both lists.	All 4.2
List.FindUnequals Finds unequal items in both lists.	All 4.2
List.GetColumn Queries a column from each line in a list.	All 11.3
List.GetValue Queries a value in the list.	All 7.1
List.HasDuplicateItems Checks if list has duplicates.	All 7.5
List.HasValue Checks whether a list contains a given value.	All 6.4
List.IndexOfFirstValueMatching Finds index of first value matching value.	All 10.2
List.InsertValue Inserts a value to a list.	All 7.1
List.MapEntries Maps selection of keys from a key list to value list.	All 11.3
List.MatchesPostfix Finds list entries which have a given postfix text.	All 5.4
List.MatchesPrefix Finds list entries which have a given prefix text.	All 5.4
List.MatchesSubString Finds list entries which contains a given text.	All 12.4
List.Not Returns values of first list which are not in second list.	All 4.4
List.NotColumn Returns values of first list which are not in second list.	All 10.0
List.Or Returns values of both lists.	All 4.4
List.OrColumn Returns values of both lists.	All 10.0
List.RegExMatch Matches a list against a pattern.	All 4.4
List.Remove Removes the value with the given index in the list.	All 7.1
List.RemoveDuplicateItems Removes duplicate items in the list.	All 4.2
List.RemoveEmptyItems Removes empty items in the list.	All 4.2
List.RemovePostfix Removes a postfix text to each entry in the list.	All 6.1
List.RemovePrefix Removes a prefix text to each entry in the list.	All 6.1
List.RemoveValue Removes a value from a list.	All 7.1
List.Reverse Reverses the order of items in the list.	All 4.4
List.Serialize Serialized a list as a text.	All 5.2
List.SetValue Sets a value in the list.	All 7.1
List.Shuffle Shuffles the items in the list.	All 14.0
List.Sort Sorts the list.	All 4.2
List.SortWithEvaluate Sorts a list with using an expression to evaluate.	All 10.2
List.SubList Returns a part of the list.	All 7.5
List.Trim Trims all texts in the list.	All 7.5
List.ValueIndex Finds the index for a given value.	All 5.4
List.XOr Returns list with values found in either first or second list, but not in both.	All 4.4
List.XOrColumn Returns list with values found in either first or second list, but not in both.	All 10.0
QuickList.AddList Adds a list of values to a quick list.	All 5.0
QuickList.AddMultiValue Adds a value or list to the list.	All 7.2
QuickList.AddPostfix Adds a postfix text to each entry in the list.	All 6.1
QuickList.AddPrefix Adds a prefix text to each entry in the list.	All 6.1
QuickList.AddQuickList Adds the content of second list to first list.	All 5.0
QuickList.AddSQL Adds values to a quick list via SQL.	All 5.1
QuickList.AddValue Adds a value to the list.	All 4.4
QuickList.And Returns a list with values which are contained in both lists.	All 4.4
QuickList.AndColumn Returns a list with values which are contained in both lists.	All 10.0
QuickList.BestMatch Looks for best match of a text in a list of texts.	All 5.0
QuickList.CSVSplit Splits CSV text.	All 7.4
QuickList.Clear Clears the content of the list.	All 4.4
QuickList.Clone Creates a clone of the list.	All 6.1
QuickList.Count Queries the count of items in list.	All 4.4
QuickList.CountValuesMatching Count matching entries in list.	All 10.2
QuickList.CrossProduct Creates the cross product from two lists.	All 6.1
QuickList.DeCombine Picks elements from each line in a list.	All 7.5
QuickList.Deserialize Restores a serialized list.	All 5.2
QuickList.Find Finds an entry in the list.	All 11.1
QuickList.FindDuplicateItems Finds duplicate items in the list.	All 10.5
QuickList.FindEquals Finds equal items in both lists.	All 4.4
QuickList.FindUnequals Finds unequal items in both lists.	All 4.4
QuickList.GetColumn Queries a column from each line in a list.	All 11.3
QuickList.GetList Queries the list as text.	All 4.4
QuickList.GetValue Queries a value in the list.	All 4.4
QuickList.HasDuplicateItems Checks if list has duplicates.	All 7.5
QuickList.HasValue Checks whether a list contains a given value.	All 5.0
QuickList.HasValues Checks whether a list contains the given values.	All 14.2
QuickList.IndexOfFirstValueMatching Finds index of first value matching value.	All 10.2
QuickList.InsertValue Inserts a value to a list.	All 5.2
QuickList.JSONArray Returns all texts in the QuickList as a JSON array.	All 14.3
QuickList.JoinJSON Joins text in a QuickList as JSON array.	All 13.3
QuickList.List Returns list of all quick list IDs.	All 5.3
QuickList.MatchesPostfix Finds list entries which have a given postfix text.	All 5.4
QuickList.MatchesPrefix Finds list entries which have a given prefix text.	All 5.4
QuickList.MatchesSubString Finds list entries which contains a given text.	All 6.0
QuickList.New Creates a new list.	All 4.4
QuickList.Not Returns values of first list which are not in second list.	All 4.4
QuickList.NotColumn Returns values of first list which are not in second list.	All 10.0
QuickList.Or Returns values of both lists.	All 4.4
QuickList.OrColumn Returns values of both lists.	All 10.0
QuickList.Pop Pops last value from the list.	All 5.2
QuickList.PopFirst Pops the first value from a list.	All 5.2
QuickList.Push Pushes a value to the end of the list.	All 5.2
QuickList.RegExMatch Matches a list against a pattern.	All 4.4
QuickList.Release Releases the list.	All 4.4
QuickList.Remove Removes the value with the given index.	All 5.0
QuickList.RemoveDuplicateItems Removes duplicate items in the list.	All 4.4
QuickList.RemoveEmptyItems Removes empty items in the list.	All 4.4
QuickList.RemovePostfix Removes a postfix text to each entry in the list.	All 6.1
QuickList.RemovePrefix Removes a prefix text to each entry in the list.	All 6.1
QuickList.RemoveValue Removes a value from a quick list.	All 5.0
QuickList.Reserve Reserves memory for a list of given size.	All 4.4
QuickList.Reverse Reverses the order of items in the list.	All 4.4
QuickList.Serialize Serialized a list as a text.	All 5.2
QuickList.SetList Sets the list to the content of the passed list.	All 4.4
QuickList.SetValue Sets a value in the list.	All 4.4
QuickList.Shuffle Shuffles the items in the list.	All 14.0
QuickList.Sort Sorts the list.	All 4.4
QuickList.SortWith Sorts the list with together with other lists.	All 6.2
QuickList.SortWithEvaluate Sorts a list with using an expression to evaluate.	All 10.2
QuickList.SubList Returns a part of the list.	All 7.5
QuickList.Trim Trims all texts in the list.	All 7.5
QuickList.ValueIndex Finds the index for a given value.	All 5.4
QuickList.XOr Returns list with values found in either first or second list, but not in both.	All 4.4
QuickList.XOrColumn Returns list with values found in either first or second list, but not in both.	All 10.0

114 functions shown.

These functions require a license (95%).

Release notes

Version 14.0
- Added CaseSensitive flag for List.FindDuplicateItems, List.HasDuplicateItems, List.RemoveDuplicateItems, QuickList.FindDuplicateItems, QuickList.HasDuplicateItems, QuickList.RemoveDuplicateItems.
- Added flags for List.BestMatch and QuickList.BestMatch to use Jaro-Winkler distance optionally and optionally return list of top 5.
- Added List.Shuffle and QuickList.Shuffle functions.
Version 12.4
- Added List.MatchesSubString function.
- Fixed a problem with List.CSVSplit, Matrix.CSVSplit and QuickList.CSVSplit not parsing properly quoted multi line value.
Version 12.3
- Fixed List.DeCombine and QuickList.DeCombine to handle the ReturnNewline parameter correctly.
Version 12.2
- Optimized List.CSVSplit, QuickList.CSVSplit and Matrix.CSVSplit to better handle lonely quotes in quoted strings.
Version 11.3
- Added List.GetColumn and QuickList.GetColumn functions to extract a column from a list.
- Added List.MapEntries function.
Version 11.1
- Added List.Find and QuickList.Find functions.
Version 10.5
- Added List.FindDuplicateItems and QuickList.FindDuplicateItems functions.
Version 10.4
- Added prefix/postfix operator for List.IndexOfFirstValueMatching, QuickList.IndexOfFirstValueMatching, List.CountValuesMatching and QuickList.CountValuesMatching.
Version 10.3
- Added numeric mode for List.CountValuesMatching, List.IndexOfFirstValueMatching, QuickList.CountValuesMatching and QuickList.IndexOfFirstValueMatching functions.

FileMaker Magazin

Example Databases

💬 Ask a question or report a problem