Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Deprecated   Guides   Examples   Videos
New in version: 10.2   10.3   10.4   10.5   11.0   11.1   11.2   11.3   11.4   11.5    Statistic    FMM    Blog  


Extracts the text from the XML tree.

Component Version macOS Windows Linux Server iOS SDK
XML 7.0 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "XML.ExtractText"; XML { ; Flags } )   More


Parameter Description Example Flags
XML The XML to process.
Can be XML as text or the reference returned by XML.Parse function, so you can make several times changes to the XML without parsing it each time.
Flags Various Flags.
Add 1 to ignore errors in xml and continue parsing. This may lead to not everything in the xml being read.
0 Optional


Returns text or error.


Extracts the text from the XML tree.
Returns a list with texts from all sub nodes.


Extracts text:

MBS( "XML.ExtractText"; "<Person><FirstName>Markus</FirstName><LastName>Müller</LastName><City>New York</City></Person>")

Example result:
New York

Custom function to get xml value as text:

GetXMLValue(xml, name)

# returns text of a xml node

Let ([
part = MBS( "XML.SubTree"; xml; name);
result = If( MBS("IsError"); ""; If(Length(part) = 0; ""; MBS( "XML.ExtractText"; part)))
]; Trim( result))

Extract text with intermediate XML node:

MBS( "XML.ExtractText"; "<Person>Hello<br/>World</Person>")

See also

Release notes

Example Databases

Blog Entries

FileMaker Magazin

Created 26th December 2016, last changed 7th May 2021

XML.DeletePath - XML.Format

Feedback: Report problem or ask question.

MBS FileMaker Plugins

Start Chat