Extract the Text

Hello Everyone
How can we extract this text from webpage

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

Output required
John XAC

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

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

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

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


Thanks @Tapan_Behera1

Thanks @Sudharsan_Ka

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.