Extract specific text value from threads private note
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
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
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))
0