AnsweredAssumed Answered

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

Question asked by goodhope on Dec 4, 2009
Latest reply on Feb 18, 2010 by bvoth

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 

 

Outcomes