URL in Datatable

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

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

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

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

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

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