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

List.ColumnMatchesPostfix

Finds list entries which have a given postfix text.

Component Version macOS Windows Linux Server iOS SDK
List 16.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "List.ColumnMatchesPostfix"; List; Separator; Column; Text { ; NoReturnEnding } )   More

Parameters

Parameter Description Example Flags
List The list of texts to search. "Hello"
Separator The separator text.
Can be multiple characters.
For tab separated text, pass Char(9). For CSV separated text, pass ";" or ",".		 Char(9)
Column The index of the column to compare.
Starts with 0 for first column.		 0
Text The text to find. "Hello"
NoReturnEnding Pass 1 to have no extra newline character on the end of the returned list. Default is 0 to include one to easily concat lists. 1 Optional

Result

Returns OK or error.

Description

Finds list entries which have a given postfix text.
We lookup the text in the column given the separator and column index and then apply the comparison there.
Comparison is case insensitive.

Examples

Finds list entries with matching postfixes:

MBS( "List.ColumnMatchesPostfix"; "1,Hello¶2,auto¶3,World"; ","; 1; "o" )

Example result:
1,Hello
2,auto

See also

Release notes

  • Version 16.3
    • Added List.ColumnMatchesPostfix, List.ColumnMatchesPrefix and List.ColumnMatchesSubString functions.

Blog Entries

This function checks for a license.

Created 21st June 2026, last changed 21st June 2026


List.CSVSplit - List.ColumnMatchesPrefix


MarkDown version: ListColumnMatchesPostfix.md