Problem in rendering HTML character codes in CSV
Reshma Hussain 01/30/2016 12:17 PM
Domino Designer All Releases All Platforms
I'm trying to export data within document fields to CSV files. The problem I'm facing here is certain fields have html character codes (for example, & # 147 ; for the special character apostrophe (')). When I export this data to CSV, I want to see the apostrophe but instead what I see is the literal text "& # 147 ;". There are many more characters such as this but I haven't found a solution so far.
I do not have access to see how the data looks in the front end. The users do not use notes client but have a different interface in the web which I do not have access to. The users of the database say that they do not see these special characters in the front-end. I can only see values through document properties. And even in the document properties I see the html codes.
Any help to resolve this in Lotusscript would be highly appreciated. Thanks in advance!