Regular Expression for is match condition

i have one txt file and it contains table i want to generate is match condition will share u screenshot pls tell me regular expression for multiple table extraction in excel

i tried this pattern “(?=Doc Type/Number Date Header Ref Gross Amt TDS Amt AMOUNT(INR))[\r\s\S]+”
my text file istext.txt (5.8 KB)

Hi @sayali_rokade

Can u show how PDF table looks like

Or instead of trying with regex try with these ways

  1. Use Epsilon ai activitiy to extract table from PDF.

  2. Document understanding

  3. Datascraping table from PDF ( rarely possible)


Nived N :robot:

Happy Automation :relaxed::relaxed:

@sayali_rokade - What are all the values you would like to extract from this text file??

Hi Daniel,

By the given data, you can extract all tables at once using the expression:


all table values.

yes i tried that already i use scope paste api license key but it is showing error in page no.

by using this only one table data m getting

Please find the workflow attached here. @sayali_rokade (14.1 KB)
And also find the output filetest.xlsx (10.8 KB)

Hope this may help you :slight_smile:

1 Like

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