list.pattern_first ( _list ; _value ; _case_sensitive )

Finds first matching pattern in list without recursion

Be the first to rate this function Log in to vote

Mohamed Tawfiq - Show more from this author
CE
https://mhtawfiq.github.io/

Sample input:

list.pattern_first ( "ABCD¶DDFG¶GGfG¶FFGG" ; "fG" ; 1 )

Sample output:

GGfG

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// list.pattern_first ( _list ; _value ; _case_sensitive )
// 20240425
// Mohamed H. Tawfiq - mhtawfiq@gmail.com
// Description: Finds first matching pattern in list without recursion
// Return: First matching list value if found, otherwise 0
// _list: Return delimited value list
// _value: Text pattern to find in _list, should not contain ¶
// _case_sensitive: Boolean | Case sensitive matching

Let(
	[
		_list = If(
			_case_sensitive;
			Substitute( _list; _value; _value & "!@#$" );
			_list
		);
		_value = If( _case_sensitive; _value & "!@#$"; _value );
		p = Position( _list; _value; 1; 1 );
		p_left = Position( _list; ¶; p; - 1 );
		p_right = Position( _list; ¶; p; 1 );
		p_right = If( p_right; p_right; Length( _list ) + 1 )
	];
	If(
		p;
		Substitute(
			Middle( _list; p_left + 1; p_right - p_left - 1 );
			"!@#$";
			""
		);
		0
	)
)

Finds first matching pattern in list without recursion

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

list.pattern_first ( _list ; _value ; _case_sensitive )

Comments

Support this website.

Support this website.