Regex to extract row from a table

Help Activities
#1

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

#2

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

#3

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 ?

#4

Can you share it in Notepad

#5

@hasib08
SampleReg.txt (126 Bytes)

1 Like
#6

Refer this regex
https://regex101.com/r/tcBPPt/2

1 Like
#7

You got solution @MLT

#8

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:

#9

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