Replace HTML codes (e.g. ")

RIchardC · December 28, 2021, 5:20pm

I have a column of strings that contain a variety of HTML codes like:

&quot;
&#39;
&amp;

And so on. I want to convert those codes to their string equivalent. Is there a function that does that?

I’ve thought about using String Replace (dictionary) but I’m hoping that’s the hard way.

Cheers, Richard

cristiancandia · December 28, 2021, 5:59pm

One alternative to your case is to use the ‘Java Snippet’ Node.

You just have to be carefully setting the input and output columns and also importing the “org.jsoup” library that would make the job.

Hope it works!!

Br,

RIchardC · December 29, 2021, 3:15am

That works perfectly. Thanks.

Replace HTML codes (e.g. &quot;)