URL in Datatable

Help Studio
, ,
1

Hi.

I have a datatable that sometimes has a link in column 1. When it’s not a link to another webpage I have to take a note of it. How would I be able to tell if its a link or not?

Thanks

1 Like
2

Hi

Welcome to uipath forum

Hope the below steps would help you resolve this

  1. Let’s take you have the datatable named dt

  2. Now use a FOR EACH ROW activity and pass dt as input

  3. Inside the loop use a IF condition like this

CurrentRow(“yourcolumnname”).ToString.ToUpper.Contains(“HTTPS”)

If true it goes to THEN block which means it’s a url if not it goes to ELSE block

Inside those blocks you can have the activities you want accordingly

Cheers @Vicky_Fegan1

3

Hi @Vicky_Fegan1 ,
Welcome to UiPath Forum :slight_smile:
Use Http Request and pass the URL and check the StatusCode is 200 then the URL is correct and valid.
use for each data table inside the loop pls follow.

HTTP Request (uipath.com)

Regards,
Arivu

4

Hi.

The data isn’t extracting as a url. It’s extracting as text. eg ‘Click here’ if that makes sense.

Sometimes click here is a link sometimes its a URL. Regardless it still extracts as ‘Click here’.

Thanks

5

If we can indicate that element
Then in that case use GET ATTRIBUTE first indicating the element and get the value of attribute URL
If it has value then let’s validate as above
And it it doesn’t have value also above expression will work

Cheers @Vicky_Fegan1

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.