I want to extract number from string

Help StudioX
,
1

Hi,

Below is the string. In this string i want to extract 201-396 value this value get change in other string the only thing which stable is the last part of string which is after 396 and Count is stable rest thing change. Now how to get the value

Count: PGI 04 201-396 mode: Unknown alarm: Unknown interface: integrated

2

@Puneet_Singh1
Give a try on regex Pattern
\d+-\d+

1 Like
3

Thanks @ppr

4

One more question how to extract PGI 04 value it might different string to string like DGI 05 or else.

5

@Puneet_Singh1 - You can try the below pattern…

image
image751×617 26.9 KB

For testing purpose, I have put both texts …

7

@prasath17

System.Text.RegularExpressions.Regex.Match(Cable,“(?<=Count:\s)\w{3}\s?\d{2}”).Value

This is returning “” null value. Please let me know where i am incorrect

8

@Puneet_Singh1 - it’s working for me…

image
image832×308 13.9 KB

9

I am storing this value Count: PGI 04 201-396 mode: Unknown alarm: Unknown interface: integrated in Cable variable and then i am using below regex
System.Text.RegularExpressions.Regex.Match(Cable,“(?<=Count:\s)\w{3}\s?\d{2}”).Value its same as you mention but its returing null.
anyways thanks for the support let me check

10

@Puneet_Singh1 - Please check if there is any additional space between the strings…

That doesn’t impact…

11

image
image1920×1080 280 KB

Dont know why i am getting null value

12

Your input to regex and the output variable is same? If so could you please use different one and try…

13

Already did that in above. My input is in strString and output storing in cable.

image
image1920×1080 254 KB

14

@Puneet_Singh1 - could you please do a write Line and print the strstring and share it with me ?

15

" Count: PGI 04 201-396 mode: Unknown alarm: Unknown interface: integrated "

16

image
image1920×1080 274 KB

17

@Puneet_Singh1 - I think there is two spaces after the colon…Please try this pattern…

image
image695×627 22.4 KB

18

Thanks Sir

1 Like
19

Count: PGI 04 201-396 mode: Unknown alarm: Unknown interface: integrated

@prasath17 sir please do one more help. How to extract 201 and 396 value i need both value in two different variable i mean 201 in one variable and 396 in another and these value will change workorder wise.

Thanks in advance. Please help i stuck here.

20

hi @Puneet_Singh1 - Please try this pattern…

image
image965×687 35.8 KB

StrMatches = System.text.regularexpressions.regex.matches(StrInput,“(\d+)-(\d+)”)

Here StrMatches is of variable type ‘MatchCollection’

Variable 1 = StrMatches(0).groups(1).tostring
Variable 2 = StrMatches(0).groups(2).tostring

1 Like
21

image
image1920×1080 294 KB

Getting this error