Skip to Content
Former Member
Oct 03, 2007 at 07:38 AM

Remove comma's and dots in a feild.


HI All,

I have a requirement to remove the commas and dots in particular string.

i hav explained like how i require the output.

note: simply if you look from last the first of special charecter is ',' then it should replace with '.' and all other ',' and '.' should be remove.

i hope this is clear.

1.200,50	should be 	1200.50
1,200.50	should be	1200.50
1200		should be	1200
1.200		should be	1.200
1,200		should be	1200
10,200.450.123	should be	10200450.123
10.200.450,123	should be	10200450.123

Can you please help me in this?

I will reward you with points.