Friday, November 30, 2018

Display Case Messages on Plain/Formatted Texts When Exporting Case Search Results


To export case responses/messages in plain formatted texts (without HTML codes), perform the following steps:
 
1. Navigate to Reports > Saved Searches > All Saved Searches > New.

2. Select Case.

3. Set the required criteria.

4. Click the Results tab and add fields as needed. For the Message column, insert this formula:

Field

Formula

Formula (Text)REGEXP_REPLACE({messages.message},'<[^<>]*>','')
 
5. Click Save and Run.
 
6. Click Export-Excel or Export-CSV.

No comments:

Post a Comment