2 Replies Latest reply on Aug 15, 2018 1:25 PM by Adi Nalla

    Extract text from clob field using REGEXP_Extract

    Adi Nalla

      Hello All,

       

      I am trying to extract "Reviewer" name part from a text field(workbook attached). The data looks something like this,

      Case
      Review
      AA-67262

      Analysis in pending status. Case reviewed by Dr. Jason Brown.

       

       

      Analysis code with particular status is updated by reviewer.

      BB-24524

      Analysis in complete status. Case reviewed by Dr. Jason

      Brown

       

       

      Reviewer analysis depends on case status.

       

      I tried using "Regexp_extract([Review],'Case reviewed by Dr.(.+)')" and I was able to extract

      "Jason Brown." for AA-67262 case and

      "Jason" for BB-24524 case, I am not sure how to get the remaining name part which is specified in the next line for this case.

       

      I am trying to extract "Jason Brown" from both cases.

       

      Any thoughts on achieving this?

       

      Thanks,

      Adi