Extract value from XML and modify

sharath123 · June 18th, 2009, 09:07 AM

Hi,

I am new to XSLT, I need a help to extract the value from XML and change that value.
I can able to do for simple XML , but not getting how to do with attributes.

I have a XML like this:

Code:

<document-list>
<documentid="66112"collection="products"primarycategoryid="cat05004"categoryids="cat05004 pcmcat67800050010">
<attribute name="startdate">2004-06-01</attribute>
<attribute name="currentpricesaletype">N</attribute>
<attribute name="onlineonly">false</attribute>
<attribute name="skulongdescription"></attribute>
<attribute name="listprice">2000</attribute>
</document>
</document-list>

I want to get the value of "listprice" (2000) and update that (Ex: listprice + 50)

How can i do this.

Please suggest me.

Thanks for any help.....

-Sharath

samjudson · June 18th, 2009, 09:16 AM

Attributes are referenced using the '@' symbol, so @name refers to the name attribute.

To do a condition based on that attribute value you would do "attribute[@name='listprice']"

I'm not sure what you mean by 'update' as you are essentially producing a brand new XML document every time you run an XSLT process, so you do not update the original, but output a modified version.

The following would match on a listprice attribute and output a new element with a increased price:

Code:

<xsl:template match="attribute[@name='listprice']">
  <attribute name="listprice"></xsl:value-of select="number(text()) + 50"/></attribute>
</xsl:template>

joefawcett · June 18th, 2009, 09:16 AM

You can't modify "in place" with XSLT. If you want to copy the whole document and just change the price then you'll need the identity template (search online). Then add a template that matches the correct attribute and changes it:

Code:

<xsl:template match="attribute[@name = 'listprice']">
  <attribute name="listprice"><xsl:value-of select="number(.) + 50 /></attribute>
</xsl:template>

sharath123 · June 18th, 2009, 09:41 AM

Thanx a lot...it worked....

sharath123 · June 18th, 2009, 10:20 AM

Quote:

Originally Posted by samjudson

Attributes are referenced using the '@' symbol, so @name refers to the name attribute.

To do a condition based on that attribute value you would do "attribute[@name='listprice']"

I'm not sure what you mean by 'update' as you are essentially producing a brand new XML document every time you run an XSLT process, so you do not update the original, but output a modified version.

The following would match on a listprice attribute and output a new element with a increased price:

Code:

<xsl:template match="attribute[@name='listprice']">
  <attribute name="listprice"></xsl:value-of select="number(text()) + 50"/></attribute>
</xsl:template>

Thanx for ypur input...
I need one more help...
Can i assign a new value for one node by calculating the values from other node...

Ex:
My XML is like this:

Code:

<document-list>
  <document id="366112" collection="products" primarycategoryid="cat05004" categoryids="cat05004 pcmcat67800050010">
    <attribute name="currentprice">3000</attribute>
    <attribute name="onlineonly">false</attribute>
    <attribute name="listprice">2000</attribute>
    <attribute name="margin"></attribute>
  </document>
</document-list>

and i want to calculate "margin" as "currentprice - listprice".
Is this possible?
Please suggest me...

Thanks
-sharath

joefawcett · June 18th, 2009, 10:45 AM

How about having a go yourself and showing what you've tried?