Use Read PDF activity to read PDF file. The output will be of datatype string.
Use string manipulation/ apply regex on the previous result and add content into a datatable.
Once all records are inserted into datatable, use write range activity to write into excel file.
Hello @NEWBEEIE, in the Xaml File go ahead and change the value marked below from object to String.
TypeArgument : is nothing but the data type of the values stored inside the IEnumerable. Since here you have the array of type string (as you are splitting the string) the Type Argument should be String.
I would request you to go through the foundation training from UiPath academy too.
varStr_Read_Data.Split({“Number of Coils Number of Paperclips”,“Example 3:”},stringsplitoptions.None)
Here we are trying to split the string variable varStr_Read_Data into various parts. Since the selection of strings on the basis of which we are doing it (the spit) is unique, as a result of that the string will always get divided into 3 parts.
Part 1: Part of the string before “Number of Coils Number of Paperclips” Part 2: Part of the string Between “Number of Coils Number of Paperclips” and “Example 3:”. Part 3: Part of the string after “Example 3:”.