Help with customizing Regex expression

I have a workflow (see attached) that is currently reading a specific table (Added HCPCS Codes) in a pdf file.

Table being read in the pdf document

After reading the pdf, its extracting a column (HCPCS) and writing that column to an excel sheet. See current output below:


However, I need some help in extracting additional columns from the pdf and write them to the excel file., so my new excel file should look like this below:

readPdfColstoExcel.zip

Hi @Yomi_Oluwadara

Can you try the below

Sequence24.xaml (21.6 KB)

Output:

HCPCS.xlsx (8.1 KB)

Regards,

1 Like

@lchirathapudi
Thanks for the input. I have a question. I noticed in the read pdf file activity, you specified the page to read. In future versions of this document, that page number will likely change, but the title of the table (Added HCPCS Codes)will not change. How can we, without using the page number, read that specific table ?

image

@Yomi_Oluwadara

Can you try the below

Sequence24.xaml (28.2 KB)

Regards,

1 Like

Thank you @lchirathapudi , both solution works, the second solution takes al least 20mins to complete compared to the 40 sec the other one took.

@Yomi_Oluwadara

How about the following?

Sequence24.xaml (28.2 KB)

Regards,

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