SSDN - Conditional XML Conversion?

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Russ Suter

Subject: Conditional XML Conversion?
Author: Russ Suter
Date: 11 Dec 2009 02:04 PM

I have some XML received from an outside source that looks like the following:

<LogEntries>
<LogEntry Guid="0DBA0BE4-0257-4F2B-BB2A-5464FA0E38BD" EntryNumber="1">
<NameValueList>
<NameValue Name="A" Value="1"/>
<NameValue Name="B" Value="2"/>
<NameValue Name="C" Value="3"/>
<NameValue Name="D" Value="4"/>
<NameValue Name="E" Value="5"/>
<NameValue Name="F" Value="6"/>
<NameValue Name="G" Value="7"/>
...
</NameValueList>
</LogEntry>
</LogEntries>

No I'm not kidding it really does look like that. However the actual names and values have been changed for simplicity's sake. What I want is to make it look like the following:

<Alphabet>
<Consonants>
<B>2</B>
<C>3</C>
<D>4</D>
<F>6</F>
<G>7</G>
...
</Consonants>
<Vowels>
<A>1</A>
<E>5</E>
...
</Vowels>
</Alphabet>

Obviously this means I'll have to do some conditional conversion so the intelligent logic knows to put consonants and vowels in the correct location. A lookup list would be fine for this purpose but I have no idea how to, or even if it can be, implemented. Can anyone offer advice?

Pseudo logic:

If (A, E, I, O, U) //where list is predefined somehow
put in <Vowels> tag
else
put in <Consonants> tag

Bob Chauvin

Subject: Conditional XML Conversion?
Author: Bob Chauvin
Date: 25 Jan 2010 04:36 PM

You will probably be able to use the xsl:if construct.

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.