XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Spencer ShearerSubject: XML to non-xml format
Author: Spencer Shearer
Date: 11 May 2005 03:08 PM
I have an XML file that I need to convert to non-xml format. The format of the file that I need to convert to is as follows. (Note: I have inserted line breaks before each one of the <or> for readability. The actual output file should not have the line breaks before the <or>.

#BIF File Built off the XML data format SDN list
sdnEntry: 6927
queryText: Bazul Dullah <in> firstName <and> Jack <in> lastName
<or> Bazul <in> lastName <and> Billy <in> firstName
<or> Bazul <in> lastName <and> Bart <in> firstName
<or> Bazul <in> lastName <and> Billy Jack <in> firstName
<or> Jack <in> lastName <and> Bazul Sampson <in> firstName
<or> Mortson <in> lastName <and> Bazul <in> firstName
<or> Bart <in> lastName <and> Bazul <in> firstName
<or> Jack <in> lastName <and>Bazul <in> firstName
<or> Harpoon <in> lastName
<or> Rush <in> lastName
<or> Bazul <in> lastName <and> Harpoon <in> firstName
<or> Bazul <in> lastName <and> Rush <in> firstName
<or> Meatwad <in> lastName <and> Fredrick Billy <in> firstName
<or> HAROUN <in> lastName <and> Fadhil <in> firstName
<or> AL Preist <in> lastName <and> Joe Seif <in> firstName
<or> Kline <in> lastName <and> Joe <in> firstName
<or> Galvante <in> lastName <and> Joe <in> firstName
<or> Galvante <in> lastName <and> Ray Billy Jack <in> firstName
<or> Jack <in> lastName <and> Johnson <in> firstName
<<EOD>>

The following XML is snippet that I took from a larger file. I had hoped to do the conversion using Stylus Studio but am getting stuck.

<sdnEntry>
<uid>6927</uid>
<firstName>Bazul Dullah</firstName>
<lastName>Jack</lastName>
<sdnType>Individual</sdnType>
<programList>
<program>SDGT</program>
</programList>
<akGalvantest>
<aka>
<uid>4870</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bazul</lastName>
<firstName>Billy</firstName>
</aka>
<aka>
<uid>4871</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bazul</lastName>
<firstName>Bart</firstName>
</aka>
<aka>
<uid>4872</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bazul</lastName>
<firstName>Billy Jack</firstName>
</aka>
<aka>
<uid>4873</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Jack</lastName>
<firstName>Bazul Sampson</firstName>
</aka>
<aka>
<uid>4874</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Mortson</lastName>
<firstName>Bazul</firstName>
</aka>
<aka>
<uid>4875</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bart</lastName>
<firstName>Bazul</firstName>
</aka>
<aka>
<uid>4876</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Jack</lastName>
<firstName>Bazul</firstName>
</aka>
<aka>
<uid>4877</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Harpoon</lastName>
</aka>
<aka>
<uid>4878</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Rush</lastName>
</aka>
<aka>
<uid>4879</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bazul</lastName>
<firstName>Harpoon</firstName>
</aka>
<aka>
<uid>4880</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Bazul</lastName>
<firstName>Rush</firstName>
</aka>
<aka>
<uid>4881</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Meatwad</lastName>
<firstName>Fredrick Billy</firstName>
</aka>
<aka>
<uid>4882</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>HAROUN</lastName>
<firstName>Fadhil</firstName>
</aka>
<aka>
<uid>4883</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>AL Preist</lastName>
<firstName>Joe Seif</firstName>
</aka>
<aka>
<uid>4884</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Kline</lastName>
<firstName>Joe</firstName>
</aka>
<aka>
<uid>4885</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Galvante</lastName>
<firstName>Joe</firstName>
</aka>
<aka>
<uid>4886</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Galvante</lastName>
<firstName>Ray Billy Jack</firstName>
</aka>
<aka>
<uid>4887</uid>
<type>a.k.a.</type>
<category>strong</category>
<lastName>Jack</lastName>
<firstName>Johnson</firstName>
</aka>
</akGalvantest>
<citizenshipList>
<citizenship>
<uid>1260</uid>
<country>Comoros</country>
<mainEntry>true</mainEntry>
</citizenship>
<citizenship>
<uid>1261</uid>
<country>Kenya</country>
<mainEntry>false</mainEntry>
</citizenship>
</citizenshipList>
<dateOfBirthList>
<dateOfBirthItem>
<uid>1258</uid>
<dateOfBirth>25 Aug 1972</dateOfBirth>
<mainEntry>true</mainEntry>
</dateOfBirthItem>
<dateOfBirthItem>
<uid>1262</uid>
<dateOfBirth>25 Dec 1974</dateOfBirth>
<mainEntry>false</mainEntry>
</dateOfBirthItem>
<dateOfBirthItem>
<uid>1263</uid>
<dateOfBirth>25 Feb 1974</dateOfBirth>
<mainEntry>false</mainEntry>
</dateOfBirthItem>
</dateOfBirthList>
<placeOfBirthList>
<placeOfBirthItem>
<uid>1259</uid>
<placeOfBirth>Moroni, Comoros Islands</placeOfBirth>
<mainEntry>true</mainEntry>
</placeOfBirthItem>
</placeOfBirthList>
</sdnEntry>

Posttop
(Deleted User) Subject: XML to non-xml format
Author: (Deleted User)
Date: 13 May 2005 04:26 AM
Hi Spencer,
this stylesheet should produce what you ask

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>

<xsl:template match="/">
#BIF File Built off the XML data format SDN list
sdnEntry: <xsl:value-of select="/sdnEntry/uid"/>
queryText: <xsl:value-of select="/sdnEntry/firstName"/> &lt;in&gt; firstName &lt;and&gt; <xsl:value-of select="/sdnEntry/lastName"/> &lt;in&gt; lastName <xsl:apply-templates select="sdnEntry/akGalvantest/aka"/>
&lt;&lt;EOD&gt;&gt;
</xsl:template>

<xsl:template match="aka">&lt;or&gt; <xsl:value-of select="lastName"/> &lt;in&gt; lastName &lt;and&gt; <xsl:value-of select="firstName"/> &lt;in&gt; firstName</xsl:template>

</xsl:stylesheet>

Hope this helps,
Alberto

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.