Extract data from Portal

Help Studio
, , , ,
1

Hello Everyone,

How can you extract data if defined in any of the below format?

Example
1)Issued No: 123
2)Issued No= 123
3)issued No- 123
4)Issued no:123

Data to be extracted is 123
If defined in any one of the above format

2

Hi @anmita

How about the syntax

System.Text.RegularExpressions.Regex.Match(YourString,"\d+$").Tostring

image

Regards
Gokul

3

HI @anmita

Another expression using Regex

System.Text.RegularExpressions.Regex.Match(YourString,"(?<=\W)\d+$").Tostring

image

4

Thanks @Gokul001 for the quick response:)

Will surely try these approach

1 Like
5

@anmita

Please check this

System.Text.RegularExpressions.Regex.Match(str,"(?<=Issued No\D*)\d+",RegexOptions.IgnoreCase).Value

Validating with issued no

image
image828×429 76.4 KB

Cheers

6

Thanks @Anil_G :slight_smile:

1 Like