Convert Currency Symbols to Strings

Updated Jan 26, 2021

Copy and paste the following formula entering your values.

{StrCollateral}.toLowerCase().indexOf("c$") != -1? "CAD": 
{StrCollateral}.indexOf("$") != -1 ? "USD" : 
{StrCollateral}.indexOf("€") != -1? "EUR" : 
{StrCollateral}.indexOf("£") != -1? "GBP":null
Previous Article How do I sign-in to K3?
Next Article Trim a Field