@rameezimtiaz - Please check the values from column FY1 to FY5…is this the output you are looking for??
Regex Pattern Link
@rameezimtiaz - Please check the values from column FY1 to FY5…is this the output you are looking for??
Regex Pattern Link
I want this entire table
Streets Improvements - 185 229 289 289 992
Traffic Control Improvements - 11 31 32 37 111
Municipal Facilities Improvements - 442 2,088 2,204 2,204 6,938
Redevelopment Improvements - - 38 161 173 372
Storm Water Improvements - - - - - -
Water Improvements - 242 297 297 322 1,158
Wastew ater Improvements - 691 691 691 691 2,764
Parks and Recreation Improvements - 3 17 17 66 103
Yes I want it like this
The problem with the regex you shared is that it will only get me data if there is word improvements in it. The thing is that i want a table after “by project category” and that table can have any data which might not contain improvements in it.
@rameezimtiaz - if you don’t put any anchor then it will become generalized…i have made it generic below…you see it started capturing the table underneath the first one also…
@rameezimtiaz - Here is the regex link
Haven’t used anything yet(waiting for your confirmation) in Uipath, I can build datatable and assign the group matches to it and finally would write the reults to excel…
@prasath17 when i use current regex it fatches all tables in the text. there are around 200 tables in my text file and i want only that table that comes after string “by project category”
I am not positive that , I can get the tables based on the criteria…you can try the below approach…
Just a thought: If you extracted the this text file from pdf, we can loop thru pdf pages and extract the page which has 'by project category ’ and if that page consist of only one page then we can use regex shared above to extract the details…
Yes this is from pdf. I have wrote the code that given me by project category text and line number.
Update :
@rameezimtiaz -
Delete_PDFPage.zip (5.3 MB)
This is the sample workflow which I have developed to delete the page contains the keyword and merge rest of the pages.
In this workflow, you can remove the pdf splitter(and Join PDF activity) in the If loop and add the Regex Matches to extract the table.
Hope this helps.
@prasath17 I have created a Workflow that does what i want. Thanks for your help.
I will need some more help from you in getting some other data from some other table.
@rameezimtiaz - Glad to know…if this resolved your query please mark my post as solution, that will close this thread.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.