I am saving value in db as formatted price eg: $1,234,567.83. now wants to do calculations on those values. But because of formatting I am not able to do it.
Asked 20 Dec, 15 at 08:08 AM
Rishu Singh Use This Custom Function:
function Cleanprice(price){
Price = price.replace("$", "").replace( ",", "").replace(" ", "");
Return Price;
}