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:



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

No comments:

Post a Comment