Whatever message this page gives is out now! Go check it out!

List functions

Last update:
May 18, 2026
Function Description
ArrayToListConverts a one-dimensional array to a list.
AscDetermines the ASCII value of a character.
ChrConverts a numeric value to a UCS-2 character.
CJustifyCenters a string to a field length.
ComparePerforms a case-sensitive comparison of two strings.
CompareNoCasePerforms a case-insensitive comparison of two strings.
DecryptDecrypts a string that is encrypted with the Encrypt function.
EncryptEncrypts a string.
FindFinds the first occurrence of a substring in a string, from a specified start position.
FindNoCaseFinds the first occurrence of a substring in a string, from a specified start position. The search is case-insensitive.
FindOneOfFinds the first occurrence of any one of a set of characters in a string, from a specified start position.
FormatBaseNConverts number to a string, in the base specified by a radix.
GetClientVariablesListFinds the client variables to which a page has write access.
LCaseConverts the alphabetic characters in a string to lowercase.
LeftReturns the leftmost count characters in a string.
LenFinds the length of a string or binary object.
ListAppendConcatenates a list or element to a list.
ListChangeDelimsChanges a list delimiter.
ListContainsDetermines the index of the first list element that contains a specified substring.
ListContainsNoCaseDetermines the index of the first list element that contains a specified substring.The function is case-insensitive.
ListDeleteAtDeletes an element from a list.
ListFilterFilters elements in a list.
ListFindDetermines the index of the first list element in which a specified value occurs.
ListFindNoCaseDetermines the index of the first list element in which a specified value occurs. The function is case-insensitive.
ListFirstGets the first element of a list.
ListGetAtGets a list element at a specified position.
ListInsertAtInserts an element in a list at a specified location.
ListLastGets the last element of a list.
ListLenDetermines the number of elements in a list.
ListMapIterates over every entry of the list and calls the closure function to work on the item of the list.
ListPrependInserts an element at the beginning of a list.
ListQualifyInserts a string at the beginning and end of list elements.
ListReduceIterates over each item of the list and calls the closure to work on the item.
ListRestGets a list, without its first element.
ListRemoveDuplicatesRemoves duplicate values (if they exist) in a list.
ListSetAtReplaces the contents of a list element.
ListSortSorts list elements according to a sort type and sort order.
ListToArrayCopies the elements of a list to an array.
ListValueCountCounts instances of a specified value in a list. The search is case-sensitive.
ListValueCountNoCaseCounts instances of a specified value in a list. The search is case-insensitive.
ReplaceListReplaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list. This function is case-sensitive.
ReplaceListNoCaseReplaces occurrences of the elements from a delimited list in a string with corresponding elements from another delimited list.
ValueListInserts a delimiter between each value in an executed query.

Share this page

Was this page helpful?
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Thank you for your feedback. Your response will help improve this page.

On this page