Strip HTML

[Anonymous]

Hi guys,

I have a field in SQL with HTML tags.

Is there a way to remove these?

<div>Twin needle stitching detailing. Double fabric hood with self coloured cords. Kangaroo pouch pocket with small hidden opening for earphone cord feed. Ribbed cuffs and hem. Worldwide Responsible Accredited Production (WRAP) certified production. 50 great colours. Soft cotton faced fabric creates ideal printing surface. <br />

<br />

<b>Washing Instructions:</b><br />

Machine wash 30&deg;. Do not bleach. Tumble dry low heat. Low iron. Do not dry clean</div>

Iconic school sweatshirt. Twin needle coverseams on neck. Raglan sleeve cuffs and waistband for extra durability. Herringbone back neck tape. Spotshield stain resistant coating for fabric protection. Fade resistant. <br > <br><b>Washing Instructions:</b><br> Suitable for 40°C wash and tumble dry <br>

I'd also like to remove &deg;

These are just a couple of examples!!

Thanks

[rwunderlich]

You can remove the newlines with a mapping. The mapping is also where you can map the entities like &deg; as well. I've updated the QlikVIew Cookbook example above to show mapping entities as well.

-Rob