How to dounescapes an HTML

Question

Hi There,

I want to ask about unescapes an HTML. How can I do unescapes of HTML using Alteryx ?

Below  is the data that I want to clean.

HTMLOne & TwoSome – ndash€300<html>€300"That silly man"alcester road"That silly man"

jrgo · Accepted Answer

@Nurul

There’s to tool or function that will do this. Best option would be to create a reference/lookup table that contains the character entity (escape string) and the actual character. Use Find Replace tool to swap them out.

https://www.freeformatter.com/html-entities.html has a table that you can copy/paste into an Excel file or into a Text Input tool in Alteryx directly.

Hope this helps!

Jimmy