Help with web table finding a particular value found on next page

[mokel.crisostomo]

Hi Guys, good day!
Ive got some problem with regards to selecting a specific value over a website wherein that said value is found on the next page and not on page 1. How am I able to do so in UiPath?

heres the table im looking at:

and if clicking that button, I should be able to select that particular record

[fernando_zuluaga]

Hi @mokel.crisostomo

what do you specifically need?, did you try using click activity and then get text activity?

[mokel.crisostomo]

I wanted to check about a record im looking for. This record is usually found on the 2nd page of the web im using. And that reocrd id usually starts with “F” (example on the image is F0014138).

My problem is how could I check on the 1st page that "im looking for an ID that contains the “F” " … and if not found, “click” the next page and when found on the 2nd page (assuming it has that record), then I can select that record

[Anil_G (Anil Gorthi)]

@mokel.crisostomo

If you are looking ro search for the value then you can use check app state or element exists in a loop if you have n number of pages …

And if the value format is always Fand 7 numbers then we can use regex selwctor to find the element

It looks somwthing like this…you need to get a good remaining attributes from ui explorer …tag ia something that I am assuming might bw different

<webctrl tag=‘tr’ innertext=‘F\d{7}’ matching:innertext=‘regex’ />

Hope this helps

Cheers

[mokel.crisostomo]

Thanks @Anil_G …
I could see this on my UI Explorer

based on your suggestion where should I put this or use this?

[mokel.crisostomo]

Got the “Table Extraction” to work guys!

The image above shows the Data that I extracted from the web table and Saved it to Excel.
Question:
Now How do I make it that only a specific value (highlighted on the image above) will be written or saved in Excel?

[Sanjit_Pal]

@mokel.crisostomo

ke it that only a specific

Hey @mokel.crisostomo ,

You can use the below linq

(From row In dtCustomers.AsEnumerable()
Where row("FCodes").ToString.StartsWith("X") Or row("FCodes").ToString.StartsWith("Y")
Select row).CopyToDataTable()

[mokel.crisostomo]

@Sanjit_Pal

(From row In dtCustomers.AsEnumerable() 
                Where row("Codes").StartsWith("X") or row("Codes").StartsWith("Y")
                Select row).CopyToDataTable()

Im having some errors whenever I tried to put the linkq on an “assign” activity T_T …

(From row In ExtractDataTable.AsEnumerable()
Where row(“FCodes”).StartsWith(“X”) or row(“FCodes”).StartsWith(“Y”)
Select row).CopyToDataTable()

[Sanjit_Pal]

@Sanjit_Pal

(From row In dtCustomers.AsEnumerable() 
                Where row("Codes").StartsWith("X") or row("Codes").StartsWith("Y")
                Select row).CopyToDataTable()

Try this one

ExtractDataTable.AsEnumerable().Where(Function(row) row(“Codes”).ToString.StartsWith(“X”) Or row(“Codes”).ToString.StartsWith(“Y”)).CopyToDataTable()

[mokel.crisostomo]

till didnt work

Ived uploaded my xaml file with similar scenario wherein I only wanted to get the values on the “Country” column. These are “UK” and “Italy”
I used this linq to try:

ExtractDataTable.AsEnumerable().Where(Function(row) row(“Country”).ToString.StartsWith(“I”) Or row(“Country”).ToString.StartsWith(“U”)).CopyToDataTable()

Sequence2.xaml (13.2 KB)