Stripping html tags within an <Actinic></Actinic> expression.

[graphicz]

<Actinic:PRICE_EXPLANATION PROD_REF="<actinic:variable name="ProductID" />" COMPONENTID=-1><actinic:variable name="RetailCustomerMessage" /></Actinic:PRICE_EXPLANATION>

Client site has many hundreds of products and the Customer Messages in Prices are full of html tags which are breaking the new responsive layout. Adding encoding="strip" to <actinic:variable name="RetailCustomerMessage" /> does not strip the html tags presumably because the expression is within an <Actinic></Actinic> expression.

How may I strip html in this circumstance?

Thank you.

[Andy@codepath]

Client site has many hundreds of products and the Customer Messages in Prices are full of html tags

Do you mean the variable itself (RetailCustomerMessage) contains styling tags, Jonathan?

e.g. This is the <strong>message</strong>

If so, I wrote a HTML stripping routine for our Catalog Export plug-in for this very purpose as I come across this problem a lot when exporting Full Descriptions, which can be littered with styling. I could apply that function to the part of the DB storing the price messages if I've understood you correctly.

[graphicz]

Yes Andy. And lots of it!
That certainly sounds like a plan, but how involved is it?

[Andy@codepath]

Yes Andy. And lots of it!
That certainly sounds like a plan, but how involved is it?

Very straightforward if you don't want to be selective. It simply removes all text between and including <> pairs.

[NormanRouxel]

Try replacing:

<actinic:variable name="RetailCustomerMessage" />

WIth:

<actinic:block php="true">echo strip_tags('<actinic:variable name="RetailCustomerMessage" encoding="perl" selectable="false" />');</actinic:block>

Works here when I try it.

[Andy@codepath]

That's neat, Norman. I was thinking of physically removing the tags from the data (as I hate to see design and content mixed up like that anyway) but that looks like a quicker fix.

[NormanRouxel]

You could also fix them for good by exporting the content tree (File / Export). Then look for all lines like:

Price,Retail,24000,0,1,1,"","<b>Wowza</b>",0

And strip any tags from such lines. A good text editor that can do regexp type search/replacements should be able to do this in a few clicks.

[graphicz]

Norman's inline fix is probably better for a client site that will be handed back as it will deal with future bad practice by the client!

Thank you both very much.

BTW Andy, is your database fix publishable or is it purchasable? Thanks!

[graphicz]

From: http://www.digocodigo.com/2012/03/co...d-and.html?m=1

Code to strip html tags in Notepad++ and leave only text

Select "Regular Expression" in Search Mode. Enter [<].*?> in Find What field and leave the Replace With field empty. Note that you need to have version 5.9 of Notepad++ for the ? operator to work.

[Andy@codepath]

Andy, is your database fix publishable or is it purchasable? Thanks!

It is not a stand-alone script but part of a larger compiled app that performs various other functions on the data.

[NormanRouxel]

Watch out if using Jonathan's bit of Notepad++ code. This will strip all HTML tags (indeed any text between < and the next >) from the entire document. Exported sites will probably contain many lines with tags that you'll need to keep.

You should only apply such an action to the lines beginning "Price,Retail,".

[graphicz]

Running into more difficulties with the client’s excessive use of html in the content dialogues breaking the new layout I realised it was usually due to an un-closed tag especially in product description.

I found the file htmlfixer.class.php (Giulio Pons, http://www.barattalo.it) and this has largely fixed the issue:

<div class="product-text">
		<actinic:block php="true" selectable="false" >
		include_once 'htmlfixer.class.php'; 
		$dirty_html = '<actinic:variable name="ProductDescription" encoding="perl" selectable="false" />';
		$dirty_html = str_replace("!!","","$dirty_html");
		$a = new HtmlFixer();
		$clean_html = $a->getFixedHtml($dirty_html);
		echo $clean_html;
		</actinic:block></div>

Such that a product description thus:

!!<<span style='font-size: 14px;'>>!!
!!<<strong>>!!A 2-part accessory which can be attached to the end of our 6mm and 8mm !!<<a href="Polypropylene_Shock_Cord_Reels.html">shock cord</a>>!! to create a handy hook fixing.

Supplied as single fixing (shock cord supplied separately)
Colour : Black


Minimum force daN required to remove hook from cable:
8mm dia. cable PE covering 30 daN
Tolerance +/- 15%!!<</span>>!!

Becomes:

<> <>A 2-part accessory which can be attached to the end of our 6mm and 8mm <shock cord> to create a handy hook fixing. Supplied as single fixing (shock cord supplied separately) Colour : Black Minimum force daN required to remove hook from cable: 8mm dia. cable PE covering 30 daN Tolerance +/- 15%>

(Shock cord displays correctly as a hyperlink. and the layout all works correctly)

However, I am unable to remove the extraneous < and >.

I would be very grateful for a nudge in the right direction.

Thank you

[NormanRouxel]

Try replacing

		$dirty_html = str_replace("!!","","$dirty_html");

With:

		$dirty_html = str_replace("!!<","","$dirty_html");
		$dirty_html = str_replace(">!!","","$dirty_html")

;

[graphicz]

I did try that but adding < or > made the expression red in SD so I assumed it was incorrect and that the < and > needed escaping somehow.

In fact it works perfectly, thank you Norman!



Full code:

<actinic:block php="true" selectable="false" >
		include_once 'htmlfixer.class.php'; 
		$dirty_html = '<actinic:variable name="ProductDescription" encoding="perl" selectable="false" />';
		$dirty_html = str_replace("!!<","","$dirty_html");
		$dirty_html = str_replace(">!!","","$dirty_html");
		$a = new HtmlFixer();
		$clean_html = $a->getFixedHtml($dirty_html);
		echo $clean_html;
		</actinic:block></div>

Credit:
"HTML FIXER v.2.05 15/07/2010
clean dirty html and make it better, fix open tags
bad nesting, bad quotes, bad autoclosing tags.
by Giulio Pons, http://www.barattalo.it"

And of course Norman who as on so very many occasions makes it work!
Thank you.

[NormanRouxel]

This works for me:

<div class="product-text">
	<actinic:block php="true" selectable="false" >
		include_once 'htmlfixer.class.php'; 
		$dirty_html = <<<ENDOFDESCRIPTION
		<actinic:variable name="ProductDescription" />
ENDOFDESCRIPTION;
		$a = new HtmlFixer();
		echo $a->getFixedHtml($dirty_html);
	</actinic:block>
</div>

Note that I've used HEREDOC syntax to get the description into a string and this requires you to put ENDOFDESCRIPTION; against the left margin (no indentation allowed for the end of a HEREDOC statement). We're using the description after SD generates it so there's no need to remove !!< and >!!.