Using the parse tool - to remove leading decimal

[kadenemcintosh]

I am using the parse tool to remove leading decimals. The result is Null on negative numbers and whole numbers.

Parse (^\d+\.\d\d) using this function 33563.03333  Result 33563.03. This result works.

-33563.03333  Result Null

43 Result Null

Please help.

[CharlieS · Accepted solution]

You could use this which puts an "or" condition in there::
(^\d+\.\d{2}|^-\d+\.\d{2}|\d+)

[kadenemcintosh]

What is the function for the whole number and numbers with one decimal place, the result is still Null

For example

Whole number  43 result Null

                         43.1 result Null

Is there an option for no decimal?

[T_Willins]

Hi @kadenemcintosh,

As much as I like RegEx (see this week's Weekly Challenge #188), this can also be done in a formula tool.