Question about Regex

[alvin.c.apostol26 (Alvin)]

Hi Everyone,

I need help with my problem.

Let say I have a dynamic string,

Example:

Possible strings:

Scenario 1:

DEP ID: 23281439

Scenario 2:

DEP ID 1393773

My goal is to extract the dynamic numbers after the DEP ID or DEP ID:

How can I do that in regex?

As per checking in chatgbt I needed to use

DEP ID[: ]?(\d+)

But it is only working in DEP ID 1393773 but not in DEP ID: 23281439

hope someone can guide me accordingly.

Regards,

[mkankatala (Mahesh Kankatala)]

Hi @alvin.c.apostol26

Try the below regular expressions,

(?<=(DEP ID\s*)|(DEP ID:\s*))[\d]+

Check the below image for better understanding,

Hope it helps!!

[DimitriLYR]

Hello, can you try on a assign :

depID = System.Text.RegularExpressions.Regex.Match(yourString, “DEP ID:\s*(\d+)”).Groups(1).Value

[alvin.c.apostol26 (Alvin)]

@alvin.c.apostol26

DEP ID 1393773

Thanks it worked on my end

[mkankatala (Mahesh Kankatala)]

It’s my pleasure… @alvin.c.apostol26

Happy Automation!!