Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to dounescapes an HTML

Nurul
7 - Meteor

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"

 

 

2 REPLIES 2
jrgo
14 - Magnetar

@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

Nurul
7 - Meteor

Thanks for the idea Jimmy.

It's really help me :)

Labels