Help with Regex expression so target result are pulled

Help Activities
, , , ,
1

I need help to identify and fix what I did wrong in my regex expression.

THE TASK I NEED TO COMPLETE.
Pull this table (pages 28-31) on the attached pdf and write it to am excel sheet

The image displays a table titled "Modified HCPCS Code APC/Status Indicators/Edit Assignments" listing HCPCS codes, effective dates, descriptions, APC assignments, status indicators, and edit information. (Captioned by AI)
The image displays a table titled "Modified HCPCS Code APC/Status Indicators/Edit Assignments" listing HCPCS codes, effective dates, descriptions, APC assignments, status indicators, and edit information. (Captioned by AI)871×797 172 KB

THE RESULT I’M GETTING

An Excel spreadsheet listing HCPCS codes with corresponding edits, mostly containing the value "9" and a few instances of "72". (Captioned by AI)
An Excel spreadsheet listing HCPCS codes with corresponding edits, mostly containing the value "9" and a few instances of "72". (Captioned by AI)597×687 7.55 KB

MY REGEX

The image shows a segment of an automation workflow in UiPath, highlighting a "For Each" activity looping through matches and using regular expressions to assign values. (Captioned by AI)
The image shows a segment of an automation workflow in UiPath, highlighting a "For Each" activity looping through matches and using regular expressions to assign values. (Captioned by AI)1152×544 35 KB

NOTE:
I also want to extract these tables from the pdf as well and write each table as a tab to the excel spreadsheet

EXTRACT THIS TOO_1
EXTRACT THIS TOO_1791×319 38.5 KB

EXTRACT THIS TOO_2
EXTRACT THIS TOO_2926×365 51.4 KB

EXTRACT THIS TOO_3
EXTRACT THIS TOO_3930×413 58.7 KB

EXPECTED RESULT
Automation should pull the content of the table on pages 28-31 and write to an Excel file file.

Attached is my workflow, I need some help- cant see what I did wrong
extract_modified.zip (1.3 MB)

2

The approach I usually use when parsing data from PDF that require RegEx:
1/ Read text from PDF (like you do now)
2/ SAVE retrieved text to a text file
3/ Analyse the retrieved text
4/ Prepare and test regex in some online regex tool like https://regex101.com/
5/ Apply the regex to UiPath workflow

Cheers

1 Like
3

Hi,

Which pages do you want to extract? The above sample reads from not 29-31 but 12-16.
If 12-16, the following will work.

regex pattern

"(?m)^(?<HCPCS>\w+)\s+(?<EffDate>\d+-\d+-\d+)\s+(?<Description>.+?)\s\s+(?<StatusIndicator>\w+)\s+(?<APC>\w+)( +(?<Edit>\w+))?"


dt_forExtractedMatches = matchesFromExtractedText.Cast(Of System.Text.RegularExpressions.Match).Select(Function(m) dt_forExtractedMatches.Clone.LoadDataRow(dt_forExtractedMatches.Columns.Cast(of DataColumn).Select(Function(c) m.Groups(c.ColumnName).Value).ToArray,False)).CopyToDataTable

Sample
extract_modified.zip (1.3 MB)

Regards,

4

@Yoichi
Thanks you, I realized I passed in the wrong page number

1 Like