How to extract a list of text (1 column only) from each row from different table

Help Studio
, ,
1

Hi,

My use case is to extract a list of text from a table and this will loop and check different pages for the their table.

I tried data scrapping but it only worked for 1 page (1 table). Since I have many pages and table to loop, any ideas how to retrieve the text?

thanks!

2

@sophiey

Can you please share some screenshots explaining your requirement?

Thanks,
Srini

3

Hi @sophiey

Did you try with the extract table data activity? it will allow you to select the button to move to the next page, this activity will retrieve all the pages in the same datatable

Here is an example

Regards!

4

For example, I have a list of projects (in web). In each project folder, i need to check the list of documents uploaded. So how do i loop and locate the table element in each project folder and retrieve the text of the document for validation. I have Project 1, 2 , 3 and so on…
image

5

@sophiey

Is those are hosted in OneDrive / Gdrive?
If so you can use those activities available in UiPath

If not then try to search some api’s where you can retrive without opening the webpage itself

Suppose if you don’t find anything then you have to go with table extraction

As above is in the list, First scrap the list of projects in a datatable and loop inside to get the list of files

check the selector as well to loop

Hope this may help you

Thanks,
Srini

6

Hi

I believe you can extract this as a list of records using Export option

Check once whether there is any option to extract that as a excel report so that the work of extraction gets reduced there

But if you would like to know on how to use extract datatable with an example would recommend to have a view on this doc

https://docs.uipath.com/activities/other/latest/user-guide/table-extraction

Cheers @sophiey

7

Hi @sophiey ,

You can use ‘Read PDF Text’ activity from UiPath.PDF.Activities package.
You will get all pages table data as text on which you can use regex for getting table rows.

Let me know if you need any help on regex.

8

All,

I was able to extract the list of files and their name, my problem now is how to use the same piece of code to check for files in multiple project folder (sharepoint)

thanks!

1 Like
9

Hello @sophiey

You have to switch the Studio to Modern Design Experience there you will find “Data Scrapping Wizard” which is used Extract Values for all the Pages. When you use that it will ask you if you want to extract data from the Multiple pages or not. If yes it will ask to navigate the “Next” button for extracting data from multiple pages.

Regards.

10

Did this video on similar topic helped on this issue

Cheers @sophiey

11

thanks for the tip but due to organisation’s policy, we are using lower version of UiPath, cant download sharepoint package.

So now I’m thinking to use dynamic selector to replace the different project name. did i use correct syntax here?
image

12

Yeah looks correct provided the first part of that attribute alone is dynamic

@sophiey

13

image
I want to use summary attribute “TEST” inside the selector editor. which webcrtl i use assign?

<webctrl parentid=‘xxx’ summary=‘TEST’ — is this correct?