Regex to extract row from a table

Capture

Hi,
I want to extract the “ABC” and then “SB” and again same for the second row using regex. I have no idea how to extract it from table which contains multiple values. Please help me with this.
Thanks in advance

First, you have to convert it into Text format and then we can apply Regex based on the Input.

Hi @hasib08 thanks for the suggestion.

if i convert it on to text like below:

Level Institution Name University / Board Name
10th ABC SB

How to apply condition on this to get the first row ?

Can you share it in Notepad

@hasib08
SampleReg.txt (126 Bytes)

1 Like

Refer this regex

1 Like

You got solution @MLT

Hi u can try this regex

(?<=10th).*

Where u can get both ABC and SB in a single string. Then u can use string Operation like split to split the both values

Hope it helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed::relaxed:

Hello MTL,
In this video, I have 17 use-cases for extracting tables from PDF and write data in Excel:

Your PDF is here:
55:50 File 11 simple PDF with protection empty Cells

Code:

Thanks,
Cristian Negulescu