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
¡Resuelto! Ir a solución.
If it is a string already, REGEX_Replace([Col1], '-0.', '-.') would work but I bet there is a cleaner way!
@Sami_Fox - Worked like a charm, thank you!
@binuacs - that's a nice clean simple way too...thank you!