_regex ( _pText ; _pExpr )

Uses regular expressions to find matching strings in a text.

Average rating: 4.8 (12 votes) Log in to vote

Wilhelm Werner - Show more from this author

Sample input:

_regex("abc1 abc11 abc21 abc32"; "abc[1|2]{2}")

Sample output:

abc11
abc21

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

/*
Returns a list of matching strings in _pText as specified by the regex _pExpr

Recursive custom function: once a string is found its first character is
substituted by some other character; here: #.

Requires Base Elements plugin version 3.2 or higher:
http://www.goya.com.au/baseelements/plugin

Note: BE_Values_Unique was renamed in later versions of the BE plugin; one could use also UniqueValues for Filemaker 16 or later.

*/
Let(
    [
        _q = BE_RegularExpression( _pText; _pExpr );
        _n = Position( _pText; _q; 1; 1 );
        _char = "#";
        _nText = Left( _pText; _n - 1 ) & _char &
        Right( _pText; Length( _pText ) - _n - 1 )
    ];
    Case(
        _n = 0;
        "";
        BE_Values_Unique( _q & ¶ & _regex( _nText; _pExpr; ) )
    )
)

_regex generates a list of matching strings found in a text. Regular expressions are used as provided by the Base Elements plugin (v.3.2 or higher).

Comments

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

_regex ( _pText ; _pExpr )

Comments

Support this website.

Support this website.