Hello Team,
I have amount field that can have values like below
123.450
123.400
123.456
123.000
I have to remove the trailing zeros and the result should be like below:
123.450 = 123.45
123.400 = 123.4
123.456 = 123.456
123.000 = 123
Can you please help here.
Best answer by ChanduMohammad
Hi
Checkout below solution,
Note: In Replace With add a space by keying in space bar from your keyboard
Use this : Replace text matching following regex with empty values
\.?0+$Hi
Checkout below solution,
Note: In Replace With add a space by keying in space bar from your keyboard
Thank you guys for your prompt support, this really helped.
Amazing
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
