Format an Amount as Currency

Brian Lillard 2019.06.06 15:55

Hello all

First I am sharing a code I wrote to format currency amounts with commas.

Secondly I could not find this anywhere in the documentation but I'd like to simplify it.

string sCurrency(string sIn){
 bool bNegative=((double)sIn<0?true:false); if(bNegative){sIn=DoubleToString(MathAbs((double)sIn),2);}
 string sDollars,sCents=StringSubstr(sIn,StringLen(sIn)-3,3),sTmp=StringSubstr(sIn,0,StringLen(sIn)-3);
 for(int iCnt=StringLen(sTmp); iCnt>=0; iCnt--){
  if((iCnt==3 && StringLen(sTmp)!=3) || (iCnt==6 && StringLen(sTmp)!=6) || 
     (iCnt==9 && StringLen(sTmp)!=9) || (iCnt==12 && StringLen(sTmp)!=12))
   {sDollars=sDollars+","+StringSubstr(sTmp,StringLen(sTmp)-iCnt,1);}
  else{sDollars=sDollars+StringSubstr(sTmp,StringLen(sTmp)-iCnt,1);}
  } return((bNegative?"-":"")+sDollars+sCents);
 }