Pdf data

Please Refer the output in Excel
image

Date use only in Give format like 12 thu only 1 colounm
that given in pdf

other coloumn are correct

That’s not Correct format to pick the value , because of only an used counter-value

there is problem

in ocr engin (Native)
it show
00:12 11:32 00:32 …
It is in row. how to get in coloum …

Please refer the Project File’s
A_T_DataTable.xlsx (8.0 KB) A_T_Jan_20.pdf (9.4 KB) A_T_JAN20_Pdfout.txt (2.3 KB) ReadPDF.xaml (14.1 KB)

If its correct means Mark it as Solution
Thanks @Shubham_Akole

whose packet install to get “preserveformating” Activity?

Can’t Understand? whose packet install to get “preserveformating” Activity?

If there is 1 string in pdf …
I want to separate this string or split string and store in the data row ???

Depends upon the PDF String you have to use split or other Function
@Shubham_Akole

error: Invalid activity or missing Activity

My string is
11:20
12:54
02:30
.
.
.
How to store in data table

Step 1 → Build Data Table :- Please Refer the Given Link :

Step 2 → Add DataRow :- Please Refer the Given Link :

you got solution for Extracting from PDF file ?

Pooja Gour .xls (35.5 KB) Main.xaml (22.3 KB)
Why the space created in total Duration…
my string is scanning like
11:30
02:32
09:20

Like this…
Whos expresion is use

Use TRIM () method of string can be used and it removes all leading and trailing white-space characters from the current String .

give me expression…

Refer the Link : How to use the trim, split, substring, remove

For each: Unable to cast object of type ‘System.Char’ to type ‘System.String’.
this error in my flow

@Shubham_Akole, if you got a solution means Mark the solution.

Thanks & Regards,
Vivek

it solution but again 1 error is …I want to also extract A,P,P,1/2P,…
It is not Write Proper…