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: 9.3   9.4   9.5   10.0   10.1   10.2   10.3   10.4   10.5   10.6    Statistic    FMM    Blog  

XML.ExtractText

Extracts the text from the XML tree.

Parameters

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.	"<test>Hello</test>"
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

Result

Returns text or error.

Description

Examples

Extracts text:

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

Example result:
Markus
Müller
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))

See also

• IsError
• XML.Parse
• XML.SubTree

Example Databases

• CURL/WebServices/magento older
• CURL/WebServices/Sales Force Test
• Utility functions/Split DDR
• XML/XML Test

Blog Entries

• Neues MBS FileMaker Plugin 8.4 - Über 5400 Funktionen in einem Plugin
• MBS FileMaker Plugin 8.4 - More than 5400 Functions In One Plugin
• MBS FileMaker Plugin, version 8.4pr1
• MBS FileMaker Plugin, version 7.0pr1
• New XML Functions in MBS FileMaker Plugin

FileMaker Magazin

• Ausgabe 3/2017, Seite 27, PDF

Release notes

• Version 8.4
  • Improved XML.ExtractText to handle CData, too.
• Version 7.0
  • Added XML helper functions: XML.ExtractText, XML.NodeNames, XML.SetVariables, XML.ListAttributes, XML.HasAttributes, XML.GetAttributes and XML.SubTree.

Created 26th December 2016, last changed 2nd February 2018

XML.DeletePath   -   XML.Format

Feedback: Report problem or ask question.