Regular Expression for is match condition

Help Studio
1

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

regexpattrn
regexpattrn1920×1080 220 KB

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)

2

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)

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed:

3

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

4

Hi Daniel,

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

^\d+\s\d+\s+[\d.]+\s+[\d.,]+\s+[\d.,]+
5

all table values.

6

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

7

by using this only one table data m getting

8

Please find the workflow attached here. @sayali_rokade

Text_DataTable.zip (14.1 KB)
And also find the output filetest.xlsx (10.8 KB)

Hope this may help you :slight_smile:

1 Like
9

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