Help in getting data from string

Help StudioX
,
1

Hello
I am a string and the value in string is dynamic. I need to extract value from that string below is the example of string.

Count: PGI 04 201-396 mode: Unknown alarm: Unknown interface: integrated
Count: PG 12 201-300 mode: Unknown alarm: Unknown interface: Unknown
Count: DG 12 201-300 mode: Unknown alarm: Unknown interface: Unknown
Count: AHG 12 201-300 mode: Unknown alarm: Unknown interface: Unknown

Here from above string i need to extract value which i marked in Italic.

Please help me out

2

Hi,

Can you try the following expression?

System.Text.RegularExpressions.Regex.Matches(yourString,"(?<=Count:\s*).*?(?=\s*\d{3}-\d{3})")

Sequence1.xaml (6.8 KB)

Regards,

1 Like
3

In StudioX, you can use the Text to Left / Right activity to extract the text, as follows:

image
image564×680 18 KB

4

Not working for
Count: PG 12 1-200 mode: Unknown alarm: Unknown
This string

5

Hi @Puneet_Singh1 - Are you trying this in Studio or StudioX? Just making sure…

6

Studio 2020.4

7

image
image1920×1080 205 KB

8

@Puneet_Singh1 - please check here