Hi All,
I have requirement to show only some part of the string from the below column value.
Could you please help me on this.
We are using Oracle 19C.
Column Value
"DC AC Legal Closing Confirmation has replied to the confirmation that conditions have been met."
"DC AIC Legal Closing Confirmation has replied to the confirmation that conditions have been met."
Expected return value
"DC AC Legal Closing Confirmation"
"DC AIC Legal Closing Confirmation"
Thanks in advance.