XSLT replace tags

larkojr · December 1st, 2016, 06:12 AM

Hi,
i'm new here, so be gentle :)
i have one program that generates XML for our clients.
here is the part of the code

Code:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:php="http://php.net/xsl" exclude-result-prefixes="php">
<xsl:output method="xml" indent="yes" encoding="UTF-8" omit-xml-declaration="yes"/>

<xsl:template match="/">


<products>
<xsl:for-each select="objects/object">
<xsl:element name="product"><xsl:attribute name="st"><xsl:value-of select="position()"/></xsl:attribute>
<xsl:element name="productID"><xsl:value-of select="sku"/></xsl:element>
<xsl:element name="productName"><xsl:value-of select="name"/></xsl:element>
<xsl:element name="url"><xsl:value-of select="product_url"/></xsl:element>
<xsl:element name="description"><xsl:value-of select="description"/></xsl:element>
</products>
</template>

Problem is that i have HTML tags in variable description. Here is the output that i have now:

HTML Code:

<p> TEXT1 TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1</p> <p> TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1 </p> <p> TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1TEXT1 </p> <p> <ul> </p> <p> <li>TEXT1TEXT1TEXT1</li> </p> <p> <li>TEXT1TEXT1TEXT1</li> </p> <p> <li>TEXT1TEXT1</li> </p> <p> <li>TEXT1 </li> </p> <p> <li>TEXT1TEXT1</li> </p> <p> <li>TEXT1TEXT1</li> </p> <p> <li>TEXT1TEXT1</li> </p> <p> </ul> </p> <p> </br> </p> <p> TEXT1TEXT1</br> </p> <p> <ul> </p>  <p> </ul>

As you can see i have way too many <p> and </p> tags, so i would like to remove all of them from variable description. How can i do that?

Thanks

mhkay · December 1st, 2016, 06:26 AM

You need to show us your input, your desired output, and your actual output.

larkojr · December 1st, 2016, 06:46 AM

Hi,
here is my output:

Code:

 <productID>BBB1111SKU</productID>
      <productName>product</productName>
      <url>http://my.domain.com</url>
      <description>&lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; . &lt;/p&gt; &lt;p&gt; text text text&lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt; text text text &lt;/p&gt; &lt;p&gt;text text text &lt;/p&gt; &lt;p&gt; &lt;/p&gt; &lt;p&gt;

Desired output:

Code:

 <productID>BBB1111SKU</productID>
      <productName>product</productName>
      <url>http://my.domain.com</url>
      <description> text text texttext text text text text text  text text text  text text text  text text text text text text  text text text  text text text

So i would need to remove all </p> and <p>

Thank you

mhkay · December 1st, 2016, 01:53 PM

You still haven't shown us your input.

larkojr · December 2nd, 2016, 03:29 PM

What do you mean with my input?
Variables are coming in from mysql table.

Thank you

mhkay · December 2nd, 2016, 06:37 PM

Your input is an XML document containing elements like objects, object, sku, name, product_url. Or if it isn't, then your stylesheet makes no sense at all.

larkojr · December 5th, 2016, 05:31 AM

Hi,
thank you for your reply.
I'm running this script in Magento administration. I've bought a plugin that takes prices of my products from mysql table and put it in xml for our clients.

mhkay · December 5th, 2016, 08:45 AM

And the plugin is invoking your transformation? Then it's supplying some XML to that transformation, and we need to know what the XML is. If you don't know, you can find out by adding <xsl:copy-of select="/"/> to your XSLT code, which will copy the input unchanged to the output.

larkojr · December 5th, 2016, 10:21 AM

Here you go. Here is the relevant code. thank you for this

Code:

 <object>
  <sku>product id</sku>
  <created_at>2016-10-10 04:44:38</created_at>
  <qty>3</qty>
  <final_price>76.6700</final_price>
  <status>Enabled</status>
  <manufacturer>vendor</manufacturer>
  <manufacturer_raw>645</manufacturer_raw>
  <name>speaker</name>
  <image>http://url.to.my.com/media/catalog/product/c/s/url-test-v1_product_02_normal.jpg</image>
  <small_image>http://url.to.my.com//media/catalog/product/c/s/url.test-v1_product_02_normal.jpg</small_image>
  <description>					<p>					Speaker test x2 Speaker test x2					</p>									<p>					Speaker test x2					</p>									<p>					Speaker test x2					</p>									<p>					Speaker test x2</br>Speaker test x2						<p>					  					</p>									<p>					  				</p>									<p>					 Speaker test x2					</p>									<p>					Speaker test x2					</p>									<p>					</ul>					</p>									<p>					</br></br>					</p>									<p>					Speaker test x2					</p>									<p>										</p>				</description>
  <msrp>91.0000</msrp>
  <tax_percent>22</tax_percent>
  <product_url>http://url.to.my.com/url.html</product_url>
  <price>93.5374</price>
  <attribute_set_name>Default</attribute_set_name>
  <images>
   <image>
    <position>1</position>
    <url>http://url.to.my.com/media/catalog/product/c/s/url_.jpg</url>
    <id>6433</id>
   </image>
  </images>
  <stock>
   <qty>3</qty>
  </stock>
  <entity_id>7086</entity_id>
 </object>
</objects>

mhkay · December 5th, 2016, 10:59 AM

That can't be the input to the transformation because it isn't well-formed XML.

My guess is that there's a CDATA section in there.

But dammit, why should I have to guess?

Even your stylesheet isn't well-formed, the end tags don't match up.