hi friends,
I have a string field in which price will be available. Price will be in the corresponding country format.
ex: for US i will be getting like 1,23,453.99.
for japan it will be getting like 234 ( no decimals).
Now i want to unformat this above price and make this like 123453.99 ( for US ) . meaning remove the comas, or periods ( which can be grouping seperators ), and digits after decimals should remain the same,
1,23,345.77 input -- output 123345.77
1234332 input - output 1234332
1.232.3434,909 input --- output 12323434.909( digits after deciamals should be 3 in this case )
how can we achieve this,
i remember the vice versa can be achieved with SET value currencty 'USD"... which will give in formatted price, but i need to get unformatted price.
any inputs..
RD