Getting error while extracting table form pdf

Help Activities
, ,
1

Hi Everyone,

I’m getting some error while extracting table from pdf, even i checked few videos about it still i’m facing some issues. I’m attaching my flow can anyone help me.PDF_TableExtraction.zip (219.5 KB)

pdferror
pdferror806×287 15.8 KB

@NIVED_NAMBIAR can you check once my flow

2

Hi @ranaprathap928
i think you are using epsilon AI activity

so it will extract the table from pdf as datatable

3

Hi @NIVED_NAMBIAR epsilon AI is not working for this and Document understanding is working but i want this to be done by String Manipulation. Check my code once i tried something but i’m getting error. i’m not able to fix that.

4

Hello,
In this movie, I have a lot of example of string manipulation (free code check description)

Thanks,
Cristian Negulescu

5

Hi @Cristian_Negulescu i tried this code i’m getting some errors. i attached my workflow in my question, please have a look and suggest me any modification.

6

Hello Rana,
I don’t see any workflow?

7

@Cristian_Negulescu - Its in his first post…Please see below…

image

8

Bad news I find your PDF in the zip but is not standard. I’m not able to create a rule with VB.NET in the same way that I show in 17 example movie.
Sorry you need to find other approach not my VB.NET logic.

9

Ok @Cristian_Negulescu thanks for the response, I will check any alternate.

10

@ranaprathap928 - Even i tried to extract using regex method but unfortunately I could not extract it fully because of service date and Type service is flowing to the next line…

image
image1426×306 11 KB

11

Yes @prasath17 this PDF format is different even I’m trying all ways but not working.

12

@ranaprathap928 - Yes agreed. I will give it another try tomorrow and let you know…

13

Sure @prasath17 thanks

14

@ranaprathap928 - Here you go…I tried now itself :wink:

image
image697×768 40.3 KB

Regex Pattern

I will try to improvise this tomorrow to see if I can capture the next line too…

15

Hi @prasath17 if you did that in uipath, can you share me the xaml, I’m not that much experienced in regex. It will be helpful for me.

16

@ranaprathap928 - Yes…That is really simple…i will share the xaml in few mins…which will show you how to convert Regex groups to datatable using LINQ.

17

Thanks @prasath17 for your help

18

@ranaprathap928 - Here you go…PDF_TableExtraction_Updated.zip (234.6 KB)

You can removed the output excel file and try running the workflow …

Hope this helps…

19

Sure @prasath17 i will check this now

20

Hi @prasath17 is code giving me 80% of solution for my problem, only missing is additional date and second column procedure number. i will check this if i can modify i will do this rest. Thanks for the solution . If you can give any suggestions for rest part please tell me i will try to implement .