How to get number if same keyword

Help Activities
, , , , , , , , ,
1

For example:

FOR ID 12335 is matched with the ID 3456

If I used regex to get the first ID 12335 I am getting the output along with second id 3356
Since both has ID as keyword how to resolve this

2

Hi!

When you’re using Regex.Match you get all the matches for your pattern.
Just fetch the first match?

Match = Regex.Match(input, pattern)
First Match= match.Groups(1).Value
3

Hi @sruthesanju

Try this

System.Text.RegularExpressions.Regex.Matches(Input,"(?<=ID\s+)\d+").First.ToString

A workflow diagram and a message box displaying the number "12335" are shown in an automation software interface. (Captioned by AI)
A workflow diagram and a message box displaying the number "12335" are shown in an automation software interface. (Captioned by AI)759×433 18.6 KB

Regards,

1 Like
4

System.Text.RegularExpresdioms.Regex.Matcjes(Input,“?<=ID\s+)\d+”, System.Text.RegularExpression.RegexOptions.Multiline).cast(of system.text.RegukarExpressions.Match). Select (Function (X) dt.Rows.Add(X.tostring().Trim())). CopyToDataTable()

How to modify this god for same keyword

5

@sruthesanju

Can you please explain brief what you want

Regards,

6

I need to modify this code for same keyword here I have used keyword ID but I got 2 IDs in same datatable 12335 and 3356

but I need to get first ID in one data table and remaining id in another datatable