Skip to Content
0
Former Member
Jul 07, 2009 at 10:14 PM

unformat the price..plshelp

44 Views

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