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
Skip to content
  • Register

    • Remove - replace URL in threads.note

    edited May 14, 2025 9:34AM in Reporting & Analytics for B2C Service 2 comments

    Hi,

    I'm working on a custom report that includes the threads.note field. Here’s a sample of how the conversation looks in that field:
    Agent: Hi how may I help you?
    Anonymous: Hi my problem is in this link     https://d111111.example.net/ksnakjdnlDKSAMD234jnda can you help me?
    Agent: https://community.oracle.com/ may help you.
    Anonymous: Thanks.

    My report columns are defined as follows:

    Account Id : $account_id

    Account Name : contacts.full_name

    Description : threads.note

    Description - Link Removed : IF( INSTR(TO_CHAR(threads.note), 'http') > 0, CONCAT( SUBSTR(TO_CHAR(threads.note), 1, INSTR(TO_CHAR(threads.note), 'http') - 1), '[LINK]', SUBSTR( TO_CHAR(threads.note), INSTR(TO_CHAR(threads.note), 'http') + INSTR( SUBSTR(TO_CHAR(threads.note), INSTR(TO_CHAR(threads.note), 'http')), ' ' ) ) ), TO_CHAR(threads.note))

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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