The regexp function needs to stop matching once it comes across a non-digit character, but it continues to match and doesn’t stop
tried this: regexp_replace(substr(CASE_CMT,instr(CASE_CMT,’FINAL CLAIM COUNT’,1,1),29), ‘[^0-9]’, ”)
expected this comment: “final claim count: 2 AAA 12345”
to return: “2”
instead, it returned this: “212345”
New contributor
Tanner Tolbert is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.