You can use xmlFM to parse any XML document within FileMaker in order to get :<\/p>\n
In contrast to several other existing FileMaker solution, xmlFM has the following advantages :<\/p>\n
Imagine you have the following XML file :<\/p>\n
\n<Document><\/div>\n<Item><\/div>\n<MsgId>Message 1<\/MsgId><\/div>\n<!– comment are ignored correctly –><\/div>\n<MsgId>Message 2<\/MsgId><\/div>\n<!– multiline comment are ignored correctly<\/div>\n<MsgId>Message WRONG<\/MsgId><\/div>\n\u00a0 –><\/div>\n<!– attributes are managed correctly –><\/div>\n<MsgId Ccy=\u00a0\u00bbENGLISH\u00a0\u00bb>Message 3<\/MsgId><\/div>\n<\/Item><\/div>\n<\/Document><\/div>\n<\/blockquote>\n<\/p>\n
You want to obtain the element content \u00ab\u00a0Message 3\u00a0\u00bb and its attribute \u00ab\u00a0ENGLISH\u00a0\u00bb ? \u00a0The solution is xmlFM :
\nGetXMLNode(\u00a0\/Document[1]\/Item[1]\/MsgId[3] )<\/em><\/p>\nSome explanations, the previous syntax is for :<\/p>\n
\n
- Go to first<\/em> occurence of root tag \u00ab\u00a0Document<\/em>\u00ab\u00a0<\/li>\n
- Then, go to its first<\/em> child tag named \u00ab\u00a0Item<\/em>\u00ab\u00a0<\/li>\n
- Finally, go to the third<\/em> occurence of it child, with the tag named \u00ab\u00a0MsgId<\/em>\u00ab\u00a0<\/li>\n<\/ul>\n
From there you will get the element content : \u00ab\u00a0Message 3\u00a0\u00bb, and its attribute : \u00ab\u00a0ENGLISH\u00a0\u00bb.<\/p>\n","protected":false},"excerpt":{"rendered":"
You can use xmlFM to parse any XML document within FileMaker in order to get : element content attribute value Advantages In contrast to several other existing FileMaker solution, xmlFM has the following advantages : xmlFM is compatible with a wide selection of\u00a0FileMaker versions xmlFM does NOT need any plugin to be installed, neither to … <\/p>\n