Check values in website

Hello community

In above image there is a website in which there are different different field as you can see like mobile number address etc.i want that bot should check each and every field that there should be value nothing should be blank each every field it should check like mobile number should cointains value address should cointains value.I tried to scrape the data but it was not coming in proper format…Please anyone has idea how can i do this?

it depends on the structure of the website elements, which has to be analyzed more in detail

possible extraction options

  • advanced data scraping
  • find children

we would also recommend to check if the labels can be further used for the value extractions

@ppr i tried with labels for extraction but iam getting values for some labels and not for other labels.

@Priyesh_Shetty
with only limited insights we can only give general hints. For us it is unknown what was done at your end in detail. So feel free to

  • share with us the url, if it is public or saved html page
    OR
  • share with us all details to the overall structures and the label, field structures (Web F12 Tools, UiExplorer)

@ppr the website cannot be opened in other system due to company policy i have used extract dataTable and here is the output below after using extract dataTable activity.

kindly note:

and also:

And

Try For Each UI Element and indicate the mobile number. See if it auto-identifies the other values. If it doesn’t, try indicated the phone number and see if that gets it to auto-identify everything else.

If FEUIE works, then it’s a simple matter of using Get Text for CurrentElement, then checking it with String.IsNullOrEmpty(currentText.Trim) to see if there is a value. If there isn’t, Throw an exception.

@Priyesh_Shetty
As Peter mentioned, how to retrieve data from application stably needs analyze.
Since your app is website, you may find the structure using F12: press F12 on your website → select the left top button (Select an element in the page to inspect it) then click your object (such as the mobile number 996xxxx).
Study the structure and share it in the post if you find any issues.
Below is the sample of the reply button of this post.

@postwick

Hello after using for each uielement i have indicated horizontal values first…Need to check the values which is infornt of investment value,gain/loss/Aum and open/inprocess which should not be blank atleast cointains some value.

If it’s that static and you know what the four labels will be, you can just use Replace to remove them and see if there is any value left. For example…

Else If CurrentElement.Contains(“Investment Value”) Then If Replace(CurrentElement,“Investment Value,”").Trim.Length > 0 Then has value Else has no value
Else If CurrentElement.Contains(“Gain/Loss”) Then If Replace…etc