ParseAllBetween ( source ; start ; stop ; startPos ; result )

Parses data between 2 strings for all occurrences in the specified source and returns them in a list

Average rating: 4.1 (46 votes) Log in to vote

David - Show more from this author

Sample input:

parseAllBetween ( "

test1

test2

" ; "

" ; 0 ; "" )

Sample output:

test1
test2

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

Let ([
    first = Position ( source; start; startPos; 1 );
    firstPos = first + Length(start);
    end = Position ( source; stop; firstPos; 1 );
    chars = end - firstPos
];

    If ( first ≠ 0;
        ParseAllBetween( source; start; stop; end + Length ( stop); List ( result ; Middle ( source ; firstPos ; chars)));
        result
    )
)

The parser finds all occurrences of the start and stop strings and returns what is in between for each in a list. It also allows for a start position to be specified, this can be set to 0 if you want to parse through all of the source. Otherwise it will start at the specified character

Comments

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

ParseAllBetween ( source ; start ; stop ; startPos ; result )

Comments

Support this website.

Support this website.