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

Text.FindBetween

Searches text for text between the two search strings.

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

(old name: String.FindBetween)

Parameters

Parameter Description Example Flags
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, whether to ignore case in search. Default is 0 for case sensitive search. 0 Optional
NthItem How many items to ignore before doing real search. Pass 1 to get second item. 0 Optional

Result

Returns found text.

Description

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.

Examples

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

Find with emojis:

MBS( "Text.FindBetween"; "🍎🍓🍒"; "🍎"; "🍒" )

Example result: 🍓

See also

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 31st January 2023


Text.FilterUTF16 - Text.FromStyles