How do i Remove the Digits After Decimal Wihout Round?

Help Studio
, ,
1

Hello

I want the Number Without Rounding …

i.e

I have Number 81.28 and I just want 81.2 without Rounding

I have tried Cdbl and Double Funtion but it Convert it to 81.3

2

Hello @kishan.savaliya
You can use Regex method

System.Text.RegularExpression.Regex.Match(YourString,"\d+.\d").ToString.Trim

image

2 Likes
3

Hi @kishan.savaliya

You can also try with below expression

"82.62557878".Substring(0,"82.62557878".IndexOf(".")+2)

image

Regards
Gokul

1 Like
4

Hi @kishan.savaliya
Try Generic
InputStr.Substring(0,InputStr.split("."c)(0).length+2)

2 Likes
5

this will fail if more than two decimals there right?

1 Like
6

Hi,
Try This
cdbl(System.Text.RegularExpressions.Regex.Match(cstr(Str_value),“([0-9]+).([0-9]{1})”).Value)

image
image848×283 7.38 KB

xaml is attached
round_off.xaml (5.0 KB)

Thanks,
Muthuraj

1 Like
7

Thanks for letting me know and i have updated the expression @megharajky

2 Likes
8

Hello. Another method would be with using String.Format

System.String.Format(“{0:0.00}”, number)

1 Like
9

Use Math.Floor

Math.Floor(81.28) will return 81. Math.Floor(81.75) will still return 81 instead of rounding up.

image

image

1 Like
10

Here is another method, which calculates number as a sum of digits:

(CInt(number) + 0.1 * CDbl(CInt(10 * number) - 10 * CInt(number)) + 0.01 * CDbl(CInt(100 * number) - 10 * CInt(10 * number)) ).toString

Fine regards, Adrian

1 Like
11

For just 1 decimal this would be:

(CInt(number) + 0.1 * CDbl(CInt(10 * number) - 10 * CInt(number))).toString

Regards, Adrian

1 Like
12

Sorry that one made a rounding for the one digit.
You may try something else:

(CInt(number) + (Microsoft.VisualBasic.Conversion.Fix(10 * number) - 10 * Microsoft.VisualBasic.Conversion.Fix(number)) / 10).toString

Fine regards, Adrian

1 Like
13

Thanks @Gokul_Jayakumar for the Perfect Solution.

14

Thanks @Gokul001 for solution

15

Thanks @Adrian_Brinas For the Solution

16

Thanks @postwick For the Solution

17

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.