Key/Value field escaping colon and comma characters to HTML encoded version.

[Neehakethi]

Parent Issue

No response

Problem Statement

Key/Value field escaping colon, comma and double-quote characters to HTML encoded version.

Content Items having key value fields storing values containing colon, comma, and double-quote characters are not displayed as expected once exported. They display the HTML-encoded values. It converts it to &#58, &#44 and &#34

Steps to Reproduce

1. Start up dotCMS with demo content.
2. Edit one of the products in the Products content type: Add a new key-value pair containing special characters like comma, colon, or " to (See attached Screenshot: Key value field added)
3. Publish the content
4. Export the content to a CSV.
5. Check the value of the key-value field stored and if It has HTML encoded values (Screenshot provided: Exported content)

Acceptance Criteria

The content in the key-value fields should be displayed as given instead of HTML-encoded values. For commas and colons, it's working, not encoded, so let's skip the encoding. Q: How are we supposed to escape quotes?? A: There is no way to escape quotes since it's a JSON inside a CSV. So, quotes will be kept as encoded.

dotCMS Version

23.01.4 23.08.16 23.01.6

Proposed Objective

Core Features

Proposed Priority

Priority 2 - Important

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

https://dotcms.zendesk.com/agent/tickets/113023

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response