How to remove numerical reference after special characters?

Hi there,

I’m trying to figure on how to remove the numerical reference after a special characters. See below for an example:

image

The original text is H & S Issue therefore i’d like to have the ‘#38;’ removed when capturing the value from that particular column. Below is the excel file.

KaiNexus-Export-06042020-223456.xlsx (11.5 KB)

Would definitely appreciate for any help.
Thanks.

Hi,

We can decode it as the following. Can you try?

System.Web.HttpUtility.HtmlDecode(text)

This returns “H & S Issue”

Regards,

Hi,

Is this the right way to do it?

I’m getting the above error.

Hi,

In my environment, it works. (There is no static error)

img20200609-1

Can you try the following sample?

Sample20200609-1.zip (18.8 KB)

You might need to add some reference for assembly or activity package…

Regards,

Hi Yoichi,

Probably due to framework issue. However, I got it fixed by using the below command:

system.Net.WebUtility.HtmlDecode(row(“Reason For Work”).ToString)

But yeah thanks for your guidance. Much appreciated.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.