K3 Documents

Trim a Field

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\\.\\-\\+]",""))
Previous Article Convert Currency Symbols to Strings
Next Article Absolute Value