Extracting numbers before decimal point

[ssubramanian]

Hi,

I am trying to extract the last 3 digits before decimal point from a fixed decimal column.

For eg, if the number is 12345.23 , I need to extract "345" and check if it is matching with some threshold. Please suggest the formula/method to be used to achieve this.

[MarqueeCrew]

Regex is for strings, so you'll need to convert it. Here's a formula for you:

Regex_replace(ToString([field]),".*?(\d{1,3})\.\d+",'$1')

Cheers,

Mark
🏝

[ssubramanian]

Thank you for the quick response. Is there any other way to do it other than Regex. I am new to Regex and find it little complicated

[MarqueeCrew]

ToNumber(Right(tostring([field],0),3))

I answered with regex because you put the regex tag.

Cheers,

Mark

[ssubramanian]

I din't find an appropriate label for this. My bad!

Thank you another solution, this formula rounds of the last digit before decimal. Is there a way to do this without rounding it off?

[MarqueeCrew]

I'd use the first regex formula to avoid rounding.

Find anything up to the first occurrence of 1-3 digits followed by a decimal point followed by any number of digits. The 1-3 digits is the first pattern group. Output the first group.

Cheers,

Mark

[ponraj · Accepted solution]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowInputResults

[ssubramanian]

Thank you so much for suggesting multiple ways to achieve it. It worked!

[ssubramanian]

Thank you so much for attaching the workflow to make it more clear. This is exactly my scenario.