1 Reply Latest reply on Feb 18, 2010 7:07 AM by bvoth

    XML - How to pick up the entire 'advert' text minus one section and dump into a Filemaker record

    goodhope

      Title

      XML - How to pick up the entire 'advert' text minus one section and dump into a Filemaker record

      Post

      Hello,

       

      I've had some help over the past few days to copy an entire XML advert from my XML document (which is a collection of adverts),  then dump this into a Filemaker field on XML import using the following code present in my XSLT:

       

      <COL><DATA><xsl:text disable-output-escaping="yes">&lt;![CDATA[</xsl:text><xsl:copy-of select="."/><xsl:text disable-output-escaping="yes">]]&gt;</xsl:text></DATA></COL> 

       

      I now find that I do indeed desire the entire textual content of my Advert but now NOT including text inside the <Metadata> . . . </Metadata> section (coloured in red, see sample XML advert below):

       

      <Notice Type="2508" Reference="8888439">

      <Metadata>

      <PublishDate>2008-08-23</PublishDate>

      <SortKey/>

      <Language>English</Language>

      <NoticeClass>Standard</NoticeClass>

      </Metadata>

      <Person>

      <PersonName>Marcia Higgs</PersonName>

      <PersonStatus>Employed</PersonStatus>

      </Person>

      <P><Text>Notice is hereby given that blah blah.</Text></P>

      <Administration>

      <Administrator><PersonName Class="Administrator"><Forename>Mike</Forename> <MiddleNames>Lambert</MiddleNames> <Surname>Jones</Surname></PersonName> Trustee</Administrator>

      <DateSigned>Dated: 12 August 2008</DateSigned>

      </Administration>

      </Notice> 

       

      Thanks again for any assistance.

       

      Regards Nick