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.
| HTML |
| One & Two |
| Some – ndash |
| €300 |
| <html> |
| €300 |
| "That silly man" |
| alcester road |
| "That silly man" |
Solved! Go to Solution.
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
Thanks for the idea Jimmy.
It's really help me :)
