TryCF Gist

trycf-gist-1713960008215-b9f77a1b-b013-6bf0-0d2e-05d00efde682.cfm

<cfscript>
    //num = "1,234,567.89";
    //num = "1.234.567,89";
    //num = "1’234’567.89";
    //num = "1 234 576.89";
    //num = "1234567.89";
    //num = "33";
    num = "100.000,484389";
    
   function standardiseDecimalNumber(num) {
        numDelimiters = reReplace(num, "\d", "", "all");
        if(numDelimiters == "" || len(numDelimiters) == 1) {
            return num;
        }
        
        thousandsDelimiter = numDelimiters[1];
        decimalDelimiter = numDelimiters[len(numDelimiters)];
        
        num = replace(num, thousandsDelimiter, "", "all");
        if(find(decimalDelimiter, num)) {
            num = replace(num, decimalDelimiter, ".", "all");
        }

        return num;
   }
   
   dump(standardiseDecimalNumber(num));
</cfscript>