Hi All, I want to extract table after a keyword from a text file. Is there any way I can do that. I am attaching a sample text. I want to search keyword “By Project Category” and extract table after it which is marked in bold. 20Return to Contents Future Years Operating Cost Summary By Project C…

@rameezimtiaz Get pdf page count Loop thru pages either using do while or using For each Inside the loop , using read pdf activity and get page range from the index Take the strinput from previous step and use contains or regex match to check if that page has that string then go ahead and apply th…

@rameezimtiaz - Please check the values from column FY1 to FY5…is this the output you are looking for?? [image] Regex Pattern <a href="http://regexstorm.net/tester?p=%28%3f%3c%3dImprovements%5cs%2b-%5cs%2b%29%28%3f%3cFY1%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY2%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY3%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY4%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY5%3e%5b%5cd.%2c-%5d%2b%29&i=20Return+to+Contents%0d%0a%0d%0aFuture+Years+Operating+Cost+Summary%0d%0a%0d%0aBy+Project+Category%0d%0a%0d%0aOperation+and+Maintenance+Impact+%281%2c000s%29%3a+FY+2021+FY+2022+FY+2023+FY+2024+FY+2025+Total%0d%0a%0d%0aStreets+Improvements+-+185+229+289+289+992%0d%0aTraffic+Control+Improvements+-+11+31+32+37+111%0d%0aMunicipal+Facilities+Improvements+-+442+2%2c088+2%2c204+2%2c204+6%2c938%0d%0aRedevelopment+Improvements+-+-+38+161+173+372%0d%0aStorm+Water+Improvements+-+-+-+-+-+-%0d%0aWater+Improvements+-+242+297+297+322+1%2c158%0d%0aWastew+ater+Improvements+-+691+691+691+691+2%2c764%0d%0aParks+and+Recreation+Improvements+-+3+17+17+66+103%0d%0a%0d%0aNet+Additional+Operating+Cost+%24+-+%24+1%2c574+%24+3%2c391+%24+3%2c691+%24+3%2c782+%24+12%2c438%0d%0a%0d%0aThe+operating+impacts+for+all+project+types%2c+shown+by+expense+type+is+shown+below.+Anticipated%0d%0arevenues+are+also+shown+below.+Detail+by+project+type+is+shown+on+the+following+pages.%0d%0a%0d%0aBy+Expense+Category%0d%0a%0d%0aOperation+and+Maintenance+Impact+%281%2c000s%29%3a+FY+2021+FY+2022+FY+2023+FY+2024+FY+2025+Total%0d%0a%0d%0aPersonnel+-+178+1%2c584+1%2c614+1%2c614+4%2c991%0d%0aContractual+Services+-+458+554+645+726+2%2c383%0d%0aSupplies+-+579+715+788+796+2%2c877%0d%0aUtilities+-+359+504+609+611+2%2c083%0d%0aInsurance+-+-+34+35+35+104%0d%0a%0d%0aTotal+O%26M+Impact+%24+-+%24+1%2c574+%24+3%2c391+%24+3%2c691+%24+3%2c782+%24+12%2c438%0d%0a%0d%0aTotal+Revenue+%24+-+%24+-+%24+-+%24+-+%24+-+%24+-%0d%0a%0d%0a21Return+to+Contents%0d%0a%0d%0aFuture+Years+Operating+Cost+Summary%0d%0a%0d%0aStreets+Project+Summary%0d%0a%0d%0a%0d%0a">Link

[image] rameezimtiaz: 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…

[image] rameezimtiaz: I want this entire table you mean you wanted to capture the categories also ??? Like below… [image]

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.

@prasath17 can u post the regex here and tell which activity u used for it?

@rameezimtiaz - Here is the regex <a href="http://regexstorm.net/tester?p=%28%3f%3cCatergory%3e.%2b%29%5cs%2b-%5cs%2b%28%3f%3cFY1%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY2%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY3%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY4%3e%5b%5cd.%2c-%5d%2b%28%3f%3d%5cs%29%29%5cs*%28%3f%3cFY5%3e%5b%5cd.%2c-%5d%2b%29&i=20Return+to+Contents%0d%0a%0d%0aFuture+Years+Operating+Cost+Summary%0d%0a%0d%0aBy+Project+Category%0d%0a%0d%0aOperation+and+Maintenance+Impact+%281%2c000s%29%3a+FY+2021+FY+2022+FY+2023+FY+2024+FY+2025+Total%0d%0a%0d%0aStreets+Improvements+-+185+229+289+289+992%0d%0aTraffic+Control+Improvements+-+11+31+32+37+111%0d%0aMunicipal+Facilities+Improvements+-+442+2%2c088+2%2c204+2%2c204+6%2c938%0d%0aRedevelopment+Improvements+-+-+38+161+173+372%0d%0aStorm+Water+Improvements+-+-+-+-+-+-%0d%0aWater+Improvements+-+242+297+297+322+1%2c158%0d%0aWastew+ater+Improvements+-+691+691+691+691+2%2c764%0d%0aParks+and+Recreation+Improvements+-+3+17+17+66+103%0d%0a%0d%0aNet+Additional+Operating+Cost+%24+-+%24+1%2c574+%24+3%2c391+%24+3%2c691+%24+3%2c782+%24+12%2c438%0d%0a%0d%0aThe+operating+impacts+for+all+project+types%2c+shown+by+expense+type+is+shown+below.+Anticipated%0d%0arevenues+are+also+shown+below.+Detail+by+project+type+is+shown+on+the+following+pages.%0d%0a%0d%0aBy+Expense+Category%0d%0a%0d%0aOperation+and+Maintenance+Impact+%281%2c000s%29%3a+FY+2021+FY+2022+FY+2023+FY+2024+FY+2025+Total%0d%0a%0d%0aPersonnel+-+178+1%2c584+1%2c614+1%2c614+4%2c991%0d%0aContractual+Services+-+458+554+645+726+2%2c383%0d%0aSupplies+-+579+715+788+796+2%2c877%0d%0aUtilities+-+359+504+609+611+2%2c083%0d%0aInsurance+-+-+34+35+35+104%0d%0a%0d%0aTotal+O%26M+Impact+%24+-+%24+1%2c574+%24+3%2c391+%24+3%2c691+%24+3%2c782+%24+12%2c438%0d%0a%0d%0aTotal+Revenue+%24+-+%24+-+%24+-+%24+-+%24+-+%24+-%0d%0a%0d%0a21Return+to+Contents%0d%0a%0d%0aFuture+Years+Operating+Cost+Summary%0d%0a%0d%0aStreets+Project+Summary%0d%0a%0d%0a%0d%0a">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”

Extract table from raw text

Help Robot

prasath17 (Guru) May 15, 2021, 6:59pm 7

@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…

Topic		Replies	Views
Extract table of contents + Word document Activities word	6	1031	September 13, 2023
Regex Required to capture 2 tables Robot robot , question	30	1756	May 27, 2021
Extract table from PDF using Regex Studio	3	2333	February 24, 2021
How to extract the table using Regex or String Manipulation Studio studio , question , designer_canvas	17	2586	November 29, 2022
Extract table from PDF file Academy Feedback academic_alliance , question	2	1278	June 29, 2021

Extract table from raw text

Related topics