Extract the Text

[anmita]

Hello Everyone
How can we extract this text from webpage

Blank or contains text above
Issued Book - IQXNECY
Issued by - John XAC

Output required
IQXNECY
John XAC

[Tapan_Behera1 (Tapan Behera)]

Hi @anmita is the text is fixed? if fix then you can use regex selector for this.

[anmita]

Hi @Tapan_Behera1

The text needs to extracted from data present after this field
Issued Book
Issued by

The rows above these can contain some text or might be blank that should be ignored

[Tapan_Behera1 (Tapan Behera)]

Okay Try this regex to extract the data:
testStr=“your values”

1. System.Text.RegularExpressions.Regex.Match(testStr,“(?<=Issued Book\s?-\s).+”).ToString
2. System.Text.RegularExpressions.Regex.Match(testStr,“(?<=Issued by\s?-\s).+”).ToString

[Sudharsan_Ka]

Hi @anmita

Checkout this expression

Issued Book

System.Text.RegularExpressions.Regex.Match(InputString,"(?<=Issued Book -\s).*").ToString

Issued by

System.Text.RegularExpressions.Regex.Match(InputString,"(?<=Issued by -\s).*").ToString

Regards
Sudharsan

[anmita]

Thanks @Tapan_Behera1

[anmita]

Thanks @Sudharsan_Ka