Copy and Paste the following formula using your data where necessary.

```
{({StrCollateral}.contains("(")?-1:1)
* Double.parseDouble({StrCollateral}.trim().replaceAll(" ", "").replaceAll("[^0-9\\.\\-\\+]",""))
```

Updated Jan 26, 2021

Copy and Paste the following formula using your data where necessary.

```
{({StrCollateral}.contains("(")?-1:1)
* Double.parseDouble({StrCollateral}.trim().replaceAll(" ", "").replaceAll("[^0-9\\.\\-\\+]",""))
```

Inline referenced article