REGEX expression to get decimal number with 2 decimal points

Help Activities
,
1

Hi everyone, I am trying to get the number and only with 2 decimal points.
The “NOx (g/kWh):” is always there.

I tried (?<=NOx (g/kWh): ).*
But it did not fetch.

NOx (g/kWh): 10.97029703

2

But there are other data in the expression like SFOC (g/kWh) (MDO): 198.7866787 in the same excel cell after I extracted the data. I wanna target it one by one.

3

Hi @Irfan_Musa
Try this below Regex expression:

Matches= System.Text.RegularExpressions.Regex.Matches(stringinput,"(?!=\w)[\d]+\.+[\d]{2}")

(Datatype of Matches: IEnumerable(Match))

image
image1431×498 22.4 KB

Screenshot (158)
Screenshot (158)1114×865 36.6 KB

image

Hope it helps!!
Regards,

4

Hi @Irfan_Musa

(?<=NOx \(g\/kWh\):\s*)\d+\.\d{2}

image

5

Hi @Irfan_Musa

Try this

(?<=SFOC \(g\/kWh\) \(MDO\):\s+)\d+\.\d{2}

image

1 Like
6

Hi @Irfan_Musa

(?!=\w)\d+.\d{2}

image
image1005×446 19.3 KB

Hope it helps!!

7

Hi @Irfan_Musa

Try this

(?!=\w)[\d]\d+\.\d{2}

image

I hope it helps!!

8

Thank you for helping me with the quick responses. I will try all the recommendations

9

@Irfan_Musa

If you got the solution for your question. Please mark it as solution to close the thread.

Regards,

10

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