TryCF Gist

trycf-gist.cfm

<cfscript>
    source1 = '2 000,99';
    source2 = '2,000,99';

    // remove ALL commas and spaces
    example1 = REReplace(source1,"[\s,]","","all");
    example2 = REReplace(source2,"[\s,]","","all");

    // insert a decimal before the last two digits
    example1 = Insert(".",example1,(Len(example1)-2));
    example2 = Insert(".",example2,(Len(example2)-2));

    writeOutput(source1 & " = " & example1);
    writeOutput("<br>");
    writeOutput(source2 & " = " & example2);
</cfscript>