We are determining which topics we need to build out for our Knowledge Base.
We want to evaluate the first messages provided, when our Customers first submit cases to determine "primary topics" for our Knowledge Base content.
We intend to export the case Message information and use another tool to search the text results for common topics.
I am attempting a Case Saved Search that returns the 1st Case Message received.
I can accomplish this using a Formula (Text) Summary Type Formula = min(TO_CHAR({messagedate},'[yyyy/mm/dd hh:mi]')||' '||{message}) but I could not export the results. When I click any of the export icons, nothing happens.
During my trouble shooting, I found I can use the "Email" icon and send the search results
but excel file attached to the email Message includes special characters.
I can eliminate the special characters using a Formula (Text)
- Formula: REGEXP_REPLACE({message},'<[^<>]*>','') from Answer ID: 34378
I still need to combine the two Formulas:
Formula (Text), Summary Type = Minimum, Formula = min(TO_CHAR({messagedate},'[yyyy/mm/dd hh:mi]')||' '||{message}) &
Formula (Text) REGEXP_REPLACE({message},'<[^<>]*>','')
into one field so that I can return the 1st case message without special characters. I likely also have to fine tune the special character formula to remove the trailing special characters.
I have many other issues to resolve while building my search.
This question relates to any known limitation with the Saved Search Exporting process and specifically for excel when there is a Formula (Text) on the Case Message field? I can't find mention of this exception.
Any information anyone has is appreciated.
As always. Thanks!