Remove zeroes after three digit after decimal

Help Studio
, ,
1

Hi All,

I need to remove any zeroes after any integer digit after decimal.

for example if my value is $0.04500 USD, it should consider 0.045,

if the value is $0.698250 USD it should consider as 0.69825 only

and also remove $ , SPACE AND USD VALUE .

For example $0.69825 USD should be 0.69825 only. Can I achieve this in single expression?

2

@dutta.marina

Try this regex

\d+\.\d+[1-9]+

A regular expression is being used to match decimal numbers in a test string, highlighting four matches within the given text. (Captioned by AI)
A regular expression is being used to match decimal numbers in a test string, highlighting four matches within the given text. (Captioned by AI)916×330 21.8 KB

cheers

3

@Anil_G

Basically my actual value in Queue is 1.400000 . When it gets updated in application its becomes $1.40 USD
I have to compare and see its the same value . If its zero it should consider only one zero after any integer digit after decimal

For example

Make 1.400000 as 1.40 and $1.40 USD as 1.40

Similarly 1.00000 as 1.00 and $1.00 USD as 1.00
Similarly $0.0405 USD as 0.0405 and 0.040500 as 0.0405

image
image601×104 5.56 KB

This image contains specific data about an AWS service, including its SKU name, code, list price, SKU ID, and NsPayItemId, with null values for output and analytics data. (Captioned by AI)
This image contains specific data about an AWS service, including its SKU name, code, list price, SKU ID, and NsPayItemId, with null values for output and analytics data. (Captioned by AI)814×430 46.7 KB

If there multiple zeroes after integer it should consider 1.40(only one zero after integer digit) and remove $ and USD Sign

4

Hi whats about split and replace options?

Ex1: [quote=“dutta.marina, post:3, topic:784225”]
Make 1.400000 as 1.40 [/quote]

strPart1 = yourString.Split(".“c)(0)
strPart2 = yourString.Split(”."c)(1)

strFinal = strPart1 + “.” + strPart2.substring(0,2)

Ex2: [quote=“dutta.marina, post:3, topic:784225”]
$1.40 USD as 1.40
[/quote]

yourString = yourString.Replace(“$”,“”)
yourString = yourString.Replace(“USD”,“”).Trim

If you need doubleValues you can use Convert.toDouble(yourString)

Cheers!

5

@dutta.marina

Please try this

\d+\.\d{2}\d*(?<=[1-9])|\d+\.\d{2}

A regular expression pattern is being tested on a string to match and format numerical values, specifically highlighting and normalizing floating-point numbers by removing unnecessary trailing zeros. (Captioned by AI)
A regular expression pattern is being tested on a string to match and format numerical values, specifically highlighting and normalizing floating-point numbers by removing unnecessary trailing zeros. (Captioned by AI)828×1182 133 KB

Cheers

1 Like
6

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