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

[kas]

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 solution]

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

[kas]

@Sami_Fox - Worked like a charm, thank you!

[binu_acs · Accepted solution]

@kas One way of doing this with the Replace function

[kas]

@binu_acs  - that's a nice clean simple way too...thank you!