This content has been marked as final. Show 2 replies
I am trying to extract "Reviewer" name part from a text field(workbook attached). The data looks something like this,
Analysis in pending status. Case reviewed by Dr. Jason Brown.
Analysis code with particular status is updated by reviewer.
Analysis in complete status. Case reviewed by Dr. Jason
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?