How to search a specific (variable) string from html table and then copy text from the next cell on the same row?

[Jesse]

Hello,

I have one little problem. I want to search a specific (variable) string from html table and then copy text from the next cell on the same row. The string to search may not appear in the same row so that’s why I need some help.

How can I do that?

-Jesse

[Susana (Susana González Cacheiro)]

Hi @Jesse,

You could search the string and use Get Attribute Activity to know the tableRow index, etc…:

Regards,
Susana

[Jesse]

Hi @Susana

Thank you for your advice. Now I can copy text from the next cell on the same row but I don’t understand how I choose by user input variable the right row on Get Attribute?

Here is example where I need to copy information by specific string. The user input variable what automation gonna find from html table. I want to find example Company form (column 1) and then copy “Public limited company” (column 2).

https://tietopalvelu.ytj.fi/yritystiedot.aspx?yavain=20939&tarkiste=FD3B80E3D3656AD15912547886CEFA0227C1A07F

-Jesse

[Susana (Susana González Cacheiro)]

Hello @Jesse,

Hope this could help you

FindText.xaml (9.6 KB)

You should inform textSearch variable with the string " Company form" and the textResult variable will take “Public limited company” value.

Regards,
Susana

[Jesse]

Hi @Susana

Thank you, I will greatly appreciate. This will help me a lot! Unfortunately I don’t have chrome and I don’t have a permission to download it but that’s not gonna be a problem because I can change chrome to IE in Open Browser.
Can you still upload entire folder where is screenshots too. I like to build from beginning and understand how you solve my problem.

-Jesse

[Susana (Susana González Cacheiro)]

Hello @Jesse,

There it goes!

.screenshots.zip (5.7 KB)

Regards,
Susana

[anhth15 (hoanganh)]

hi @Jesse,

I have a quite similar problem with you

How to tick a radio button based on another value in the same row in a data table in a web app

Hi everyone, I am a beginner in uipath. Now I meet a problem with my project. I have a web app which contains a data table as the image in the attachment file as below.! [selectRadio] I want to tick on the radio button at the row which contains ID value equal to a specific value( this value is gotten from an input file). for example, I want to tick on radio button at the row which contains ID value is ID04 as the image in the attachment file. I searched google for the solution but no usef…

best regards,
Hoang Anh.

[Jesse]

Hi @Susana

Thanks
okey, there is still a problem when I changed from chrome to IE. I changed BrowserType to IE in Open Browser. Then I did again indicate to screen in Find Element text and Get text column and wrote String.Format… to selectors etc. Should be the same as yours code so it should be working.

I received this error message. Is this common error message in IE or can be it repaired somehow? I read that error message is due to the UiPath Version. I should have been the latest version of Uipath (2016.2.6379).

Can you check my code if there is some issues what causes this error (see the attachment)? Do you have any solutions how this can be done with IE?

I attached my code:
Find text test.zip (15.2 KB)

Sorry if I do any extra effort for you

Best regards Jesse

[Susana (Susana González Cacheiro)]

Hi @Jesse,

There it goes a new version Find text test_v2.zip (18.2 KB)
. There was a problem with the selector and the language selected.

Have you been through the RPA Academy? It’s free to join.

Free RPA Courses - Robotic Process Automation Training | UiPath

Regards,
Susana

[Jesse]

Hi @Susana

Its working! Thank you so much.
I must be considered to join RPA Academy.

Best Regards, Jesse