| 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
