Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 7.5   8.0   8.1   8.2   8.3   8.4   8.5   9.0   9.1   9.2    Statistic  


Searches text for text between the two search strings.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Text 3.0 Yes Yes Yes Yes Yes
MBS( "Text.FindBetween"; Text; StartTag; EndTag { ; IgnoreCase; NthItem } )   More

(old name: String.FindBetween)


Parameter Description Example value
Text The text to search inside. "<x>Hello</x>"
StartTag The first search text, e.g. start tag. "<x>"
EndTag The end tag to search, e.g. second search text. "</x>"
IgnoreCase Optional
Optional, whether to ignore case in search. Default is 0 for case sensitive search.
NthItem Optional
How many items to ignore before doing real search. Pass 1 to get second item.


Returns found text.


Searches text for text between the two search strings.
This function is useful for quickly scanning XML documents.

For more complex XML queries, please use XML.Query function.


Find CountryCode value in some XML:

MBS("Text.FindBetween"; $result; "<v6:CountryCode>"; "</v6:CountryCode>")

Find second value tag text:

MBS("Text.FindBetween"; $result; "<v6:Value>"; "</v6:Value>";0; 1)

Find second item:

MBS("Text.FindBetween"; "<1><2><3>"; "<"; ">"; 0; 1)

Example result: 2

See also

Example Databases

Blog Entries

Created 18th August 2014, last changed 20th October 2018

Text.FileExtensionToMimeType   -   Text.InvalidCharactersForEncoding

Feedback: Report problem or ask question.

MBS Xojo tutorial videos