GetListAsXML ( theList ; Element )

Easily convert a list to XML

Average rating: 4.5 (34 votes) Log in to vote

Andy Knasinski - Show more from this author
nrg software, llc.
http://www.nrgsoft.com

Sample input:

GetListAsXML ( "Value 1¶Value 2¶Value 3" ; "Value" )

Sample output:

Value 1
Value 2
Value 3

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

// Description:
// GetListAsXML ( theList ; Element )
// A recursive function that takes a list of values
// and returns an XML string with each value containing an XML prefix/suffix

// Written by Andy Knasinski
// www.nrgsoft.com

// sample
// GetListAsXML ( "Value 1¶Value 2¶Value 3" ; "Value" )
// would return an XML string for all fields on the current layout


If ( IsEmpty ( theList );
theList;

Let ([curValue = GetValue ( theList ; 1 ) ];
	"<" & Element &">" &
    curValue &
    "</" & Element & ">" &
    If ( ValueCount ( theList ) > 1 ; "¶" ; ""  ) &
    GetListAsXML (
       RightValues ( theList ; ValueCount ( theList ) - 1 ) ;
       Element
        )
	)
)

Recursive function to convert a list of values (return delimited) to XML syntax

Comments

		comment, VR Aug 6, 2009
I'm not sure why this would be needed, but if so, it can be calculated directly without recursion: Let ( [ openTag = "<" & elementName & ">" ; closeTag = "<" & elementName & "/>" ] ; openTag & Substitute ( listOfValues ; Â¶ ; closeTag & Â¶ & openTag ) & closeTag )

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetListAsXML ( theList ; Element )

Comments

Support this website.

Support this website.