XML.Format

Formats XML document.

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. Add 8 to remove all namespaces before query to have queries easier. (new in 6.3) Add 64 to skip prefix line with xml version.	0	Optional

Result

Returns XML or error.

Description

Examples

Format the document:

MBS("XML.Format"; Canonical XML::Input XML; 1)

Format removing namespace:

MBS( "XML.Format"; "<cfdi:Invoice invoiceTotal=\"450.24\"> </cfdi:Invoice>" ; 8)

Check if XML is valid:

MBS( "XML.Format"; "<hello></Hello>";0 )

Example result: [MBS] Failed to parse XML: Opening and ending tag mismatch: hello line 1 and Hello

Format in Auto-Enter calculation:

MBS("XML.Format"; self)

// put this calculation into a field, so the field gets colorized whenever the field is changed and the record gets commited.

Colorize and format in Auto-Enter calculation:

Let ( [
xmlFormatted = MBS("XML.Format"; Self);
xmlFormatFailed = MBS("IsError");
xmlText = If(xmlFormatFailed; Self; xmlFormatted);
result = MBS("XML.Colorize"; xmlText)
]; result )

// put this calculation into a field, so the field gets formated and colorized whenever the field is changed and the record gets commited.

See also

• FM.SQL.XMLRecords
• IsError
• Text.AddLineNumbers
• XML.Colorize
• XML.Compact
• XML.ItemRefs
• XML.Parse
• XML.SetSaveNoEmptyTags

Release notes

• Version 13.0
  • Added new option to XML.Compact and XML.Format to skip the ?xml line with version details.
• Version 7.5
  • Improved XML.Format function and xml parsing to better handle blank areas.

Example Databases

• CURL/Amazon S3/Amazon S3 Buckets
• DynaPDF/List XFA Streams
• DynaPDF/ZUGFeRD
• Mac only/Script Workspace Context Menu Commands
• XML/Canonical XML
• XML/XML and JSON
• XML/XML Colorize
• XML/XML Test
• XML/XML to JSON

Blog Entries

• MBS FileMaker Plugin, version 12.6pr1
• New in version 11.5 of MBS FileMaker Plugin
• FileMaker records to XML or JSON
• News about the MBS FileMaker Plugin 10.2
• MBS FileMaker Plugin 10.2 - More than 6200 Functions In One Plugin
• Fun with While function in FileMaker
• MBS FileMaker Plugin 8.3 released
• Colorize JSON or XML in FileMaker with line numbers
• MBS FileMaker Plugin, version 7.5pr8
• MBS FileMaker Plugin 6.2 for OS X/Windows

This function checks for a license.

Created 20th May 2016, last changed 28th November 2022

XML.ExtractText - XML.GetAttribute