FileMaker Pro Custom Functions

// GetXMLNode ( XML ; XPath ) // Requires ExtractData ( XML ; Attribute ; Instance ) // ExtractData can be found at http://www.briandunning.com/cf/1 // Thanks to Andy Knasinski of NRG Software for the great base function! // *** Parameter Description *** // XML - vanilla xml imput without attributes // XPath - basic XPath like syntax consiting of // a series of xml nodes formatted as follows: // /nodeName[instanceNumber] Evaluate ( Substitute ( Filter ( XPath ; "/" ) ; "/" ; "ExtractData ( " ) & "\"" & XML & "\"" & Substitute ( XPath ; [ "/" ; ";\"" ] ; [ "[" ; "\";" ] ; [ "]" ; ")" ] ) ) /**************************************************************** Nonrecursive, this function simply creates multiple nested instances of GetXMLData in a calculation string and then evaluates it to get the data. ************************* EXAMPLE USE *************************** XMLfield is set to: <class> <teacher> <name>Kelly</name> </teacher> <students> <student> <name>Bill</name> <age>15</age> </student> <student> <name>Sue</name> <age>16</age> </student> </students> </class> GetXMLNode ( XMLfield ; "/class[1]/teacher[1]/name[1]" ) & "¶" & GetXMLNode ( XMLfield ; "/class[1]/students[1]/student[2]/age[1]" ) & "¶" & GetXMLNode ( XMLfield ; "/class[1]/students[1]/student[1]" ) Will produce the following: Kelly 16 <name>Bill</name><age>15</age> **************************************************************** ****************************************************************/
 Then copy & paste into FileMaker Advanced's Edit Custom Function window.