Symptom
When a Custom Note field is exported from data workbench, it consists of HTML tags.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Add data into a custom note(rich text editor) field
- Perform an export of this data using data workbench
- The exported excel field displays the data along with tags (Example tags :<div><p><strong>)
Cause
The is because the custom note(Rich text editor) field is a "Formatted Text" field. In a formatted text field, the data is stored in the backend along with these HTML tags. Since, Data Workbench pulls the data from the backend, the data is displayed for this field with the HTML tags.
Resolution
In order to avoid these tags, it is suggested to use a "Text" type field instead of a "Formatted Text" type field.
Keywords
Custom Note FIeld, HTML Tags, Export, Data workbench, Excel , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-CRM-ACC , Account , Problem