String Manipulation to get the number between

[Umer_Shahid]

Hi,

I am receiving the following string: Sev 04/03/23 / 4 / DDP2

I want the number after the date i.e., 4. Another example is Sev 04/03/23 / 2 / DDP2. Here 2. Can someone write a one-liner for me to extract the number?

Thanks.

[fernando_zuluaga]

Hi @Umer_Shahid

What about the following?

System.Text.RegularExpressions.Regex.Match(strInput, "(?<=\/\s)\d+(?=\s\/)").Value

Regards!

[Steven_McKeering]

Hey @Umer_Shahid

Here is another regex pattern which is ‘anchored’ on the date.

System.Text.RegularExpressions.Regex.Match(strInput, “(?<=\d{2}.\d{2}.\d{2} . )\d+”).Value

.NET Regex Tester - Regex Storm

Hopefully this helps,

Cheers

Steve

[Umer_Shahid]

@Steven_McKeering

System.Text.RegularExpressions.Regex.Match(strInput, “(?<=\d{2}.\d{2}.\d{2} . )\d+”).Value

Works. Thank you.