RegEx Based Extractor about extracting Table

[lojyehuang (Lo-Chieh)]

Hi , I tried to extract Table from .pdf , but I can only extract one row in the table I defined.(Items #1)

Can anyone help me extract “Items #1” , “Items #2” and so on ?

Thanks for reading my problem.

poML.zip (165.2 KB)

[Pratik_Wavhal]

Hi @lojyehuang

Below is the Regex for the same :-

regex101: build, test, and debug regex

Below is the workflow for the same :-
MainPratik.xaml (8.9 KB)

Output :-

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[lojyehuang (Lo-Chieh)]

Thanks @Pratik_Wavhal for your fast reply.

your solution works fine.
Did you mean we can not use Regex based extractor to get each row about “item” ?
It seems that “item #1” and “item #2” will show in one row.
If we can’t solve this problem, I think your solution is the best answer.

[Pratik_Wavhal]

hi @lojyehuang

Did you mean we can not use Regex based extractor to get each row about “item” ?

Not like that.
May be that will also work by some way but as i thought it is more easy to extract by Regex using Matches Activity for this type of formatted data.
So i provided that solution.

If this helps you then Mark as solution and like it

Happy Automation

Best Regards
Er Pratik Wavhal