I’m trying to figure on how to remove the numerical reference after a special characters. See below for an example:
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.
We can decode it as the following. Can you try?
This returns “H & S Issue”
Is this the right way to do it?
I’m getting the above error.
In my environment, it works. (There is no static error)
Can you try the following sample?
Sample20200609-1.zip (18.8 KB)
You might need to add some reference for assembly or activity package…
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.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.