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
Click to copy