Removing a leading zero that's between a negative symbol and the decimal

Question

Hello All,

Having trouble figuring out regex as a fix for this, unless there's an easier way.

This is what I have:            This is what I'd like:

-0.5100                               -.5100
-0.9800                               -.9800
-0.6900                               -.6900
-0.0700                               -.0700
-0.2600                               -.2600
-0.0800                               -.0800
-0.2400                               -.2400
-0.8100                               -.8100
-0.0800                               -.0800
NONE                                 NONE
-0.5000                               -.5000
5214.3700                          5214.3700

Thanks in advance!

Kim

Sami_Fox · Accepted Answer

If it is a string already, REGEX_Replace([Col1], '-0.', '-.') would work but I bet there is a cleaner way!

binu_acs · Accepted Answer

@kas One way of doing this with the Replace function