Use RegEx to round/fixed minimum number of decimals...

[Grovkillen]

Hello,

Here's a code snippet I just made which will cut a given number to a set number of decimals. It might give someone else an idea...

Code: Select all

//Change this to what you are using as a separator
Let>DecimalSeparator=.
//Change this to the number of decimals you want
Let>NumbersOfDecimals=2
//Mess around with this...
Let>ValueToRound=121210125.490521010210

Let>NumbersOfDecimals_Temp=%NumbersOfDecimals%+1
Let>RegExPattern=(\d+\%DecimalSeparator%)\d{0,%NumbersOfDecimals_Temp%}
RegEx>%RegExPattern%,%ValueToRound%,0,MatchArray,NumMatches,,,
If>NumMatches>0
    Let>RegExPattern=%DecimalSeparator%([0-9]){0,%NumbersOfDecimals%}(?=[5-9])
    RegEx>%RegExPattern%,%MatchArray_1%,0,,NumMatches,,,
    If>NumMatches>0
        Let>RegExPattern=(\d+\%DecimalSeparator%)\d{0,%NumbersOfDecimals%}
        RegEx>%RegExPattern%,%MatchArray_1%,0,MatchArray,NumMatches,,,
        RegEx>\%DecimalSeparator%,%MatchArray_1%,0,,NumMatches,1,.,MatchArray_1
        Let>AddRound={1/(10^%NumbersOfDecimals%)}
        Let>MatchArray_1=%MatchArray_1%+%AddRound%
        RegEx>\.,%MatchArray_1%,0,,NumMatches,1,%DecimalSeparator%,MatchArray_1
    Else>
        Let>RegExPattern=(\d+\%DecimalSeparator%)\d{0,%NumbersOfDecimals%}
        RegEx>%RegExPattern%,%MatchArray_1%,0,MatchArray,NumMatches,,,
        RegEx>\.,%MatchArray_1%,0,,NumMatches,1,%DecimalSeparator%,MatchArray_1
    Endif>
    MDL>MatchArray_1
Else>
    MDL>No " %DecimalSeparator% " found!%CRLF%%CRLF%%ValueToRound%
Endif>

[Jerry Thomas]

This is code I have used through the years.
One big advantage of this approach, is that it is easier for someone else to understand. Yes, RegEx is extremely powerful, but it isn't the easiest to read and know what the code is doing.

Code: Select all

//Change this to the number of decimal places you want
Let>NumDecimals=2
//Mess around with this...
Let>ValueToRound=123.45678

// Set Multiplier as 10, 100, 1000 etc.
Let>Multiplier={Power(10,%NumDecimals%)}

Let>NewValue={Round(%ValueToRound%*%Multiplier%)}
Let>NewValue=NewValue/Multiplier

MDL>       Initial Value: %ValueToRound%%CRLF%Rounded Value: %NewValue%

[Jerry Thomas]

This is code I have used through the years.
One big advantage of this approach, is that it is easier for someone else to understand. Yes, RegEx is extremely powerful, but it isn't the easiest to read and know what the code is doing.

Code: Select all

//Change this to the number of decimal places you want
Let>NumDecimals=2
//Mess around with this...
Let>ValueToRound=123.45678

// Set Multiplier as 10, 100, 1000 etc.
Let>Multiplier={Power(10,%NumDecimals%)}

Let>NewValue={Round(%ValueToRound%*%Multiplier%)}
Let>NewValue=NewValue/Multiplier

MDL>       Initial Value: %ValueToRound%%CRLF%Rounded Value: %NewValue%

[Grovkillen]

Thanks for sharing Jerry, my problem was that the values all used "," for decimal separator and the {} expressions aren't compatable with that... it only uses "dot".

[thomasusa80]

It is program code I have utilized through the years.
A single large benefit from this process, can be it's less complicated with regard to other people to comprehend. Indeed, RegEx is quite powerful, however it just isn't the simplest to read and understand what this program code is performing.