Sunday, May 12, 2019

Exporting a Case Saved Search > Remove the Special Characters from the Message Field

Exporting a standard Case Saved Search with the Message text field sometimes gives result of a CSV file with the message field shown in html format, meaning there will be special characters like <, {, [, ^, etc.. to remove the special characters when exporting your messages you can use a formula from your Saved Search > Result Subtab.

1. Reports > New Search > Choose Case
2. Criteria and Results subtabs > set as needed
3. Under Results > Add Formula (Text):

  • Formula: REGEXP_REPLACE({messages.message},'<[^<>]*>','')
4. Save & Run

Note: This will remove hyper links, images and anything else embedded in the messages if there are any.

No comments:

Post a Comment