Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Extract specific text value from threads private note — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extract specific text value from threads private note

Received Response
11
Views
1
Comments
edited Aug 11, 2021 6:25AM in Agent Desktop 1 comment

Content

Hi all,

I have a field in report that needs to display specific text value from the private note (please see attached). Here is the private note structure: 

----------------------------------------------private note start----------------------------------------
Internal Request
 
AH ID: id
Topic: some value
Field 1: some value
Field 2: some value
Field ..: some value

Additional Details: this is the text that needs to extracted and shown in a report field
----------------------------------------------private note end----------------------------------------
 
The Additional Details always comes in the end of the private note. 
I tried to use the following expression which did not work: 
if(threads.entered = min(threads.entered) & threads.acct_id = 12345, substr(threads.note, instr(to_char(threads.note), 'Additional Details:') + 19))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!