Copy and Paste the following formula using your data where necessary.
{({StrCollateral}.contains("(")?-1:1)
* Double.parseDouble({StrCollateral}.trim().replaceAll(" ", "").replaceAll("[^0-9\\.\\-\\+]",""))
Click to copy