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.0 ✅ 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   New in 14.0
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.IndexOfFirstValueMatching
Finds index of first value matching value.
All
10.2
QuickList.InsertValue
Inserts a value to a list.
All
5.2
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   New in 14.0
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

112 functions shown.

These functions require a license (95%).

Release notes

Blog Entries

FileMaker Magazin

Example Databases