I Want to extract the Employee id, Name ,Date hours from multiple PDF and put this data in Excel file…
Use Read Pdf text with OCR
and then use matches activity and then use write cell activity to enter the details
But in pdf number name and digit available then how to extract
use matches activity to get the number and name and digit
A_T_Jan_20.pdf (9.4 KB)
in above pdf i want to extrack Employee ID ,Name ,Today Date and total Duration
give the regex expression
for date as
For Code as
It use with Bracket ???
yes in regex expression we need to give
Sequence.xaml (9.9 KB)
why file is not created??
Find the code in the link : ExtractEmpDetails.xaml - Google Drive
PS: Please read the annotations written for each arguments. Hope it helps.!
@Shubham_Akole, You got Solution ah?
no. please send if available
in my pdf I want to extract all total duration with date and save to excel
@Shubham_Akole, Please refer the Output screenshot for your PDF file.
if its correct means … i will send the XMALfile to you
sorry ,your image is not loaded
12 thu 12.08
13 wed 11.55
Like that…with Employee Id and Name
create separate excel for each
@Shubham_Akole, You want Daywise TotalDuration ah?
EmployeeID Name Date Tduration
47 Ashutosh 12 thu 12.08
13 web 11.55