Multiple links and extract specific element

Guys, Can you share any ideas??
Thank you,
Nirmalya Sarkar.

Hi @nirmalya.sarkar
I think u had extracted the name and url associated with that name.
and then u are looping through the url ,

My suggestion to ur approach of the process design should be like this:

  1. Use Datascrape option to scrap the name of company and link associated with name of company

  2. Now u had stored everything in datatable, now loop through each row using for each row activity.

Inside it do the following :

a. Use attch browser option indicating the main home page where the all data are presented in list format [where u had datascrapped], inside it use the Navigate To Activity to naviage to the another link which is the link stored under datatable
b. once u had reached the webpage, use Get Text/Get Attribute Activity to extract the website link.

this is the way u can try

If possible can u share the website so that i can try and share the results back to u

Nived N
Happy Automation

@NIVED_NAMBIAR , thank you for your detailed explanation.
The website link is - List of Manufacturing Companies in Kolkata -
If you solve the problem, please share the xaml file with me.

Nirmalya Sarkar.

Hi @nirmalya.sarkar
Check this workflow (4.2 MB)

Nived N

@NIVED_NAMBIAR , you only scrap for 100 data. My task is to scrap all the “websites” by clicking “Next”. Please help me.

Nirmalya Sarkar.

Ya in that max number of results put 0 instead of 100

It will scrap all results

@NIVED_NAMBIAR , I know this part. What I am asking is - this time site will not block itself right??

Yes site won’t block itself

You can try this around

Also please mark the answer as solution if it solves ur query


Nived N

@NIVED_NAMBIAR , Okay I am working on it. If I get the result , I will mark it as " Solution".
But I have another query.

In this picture , I have to split the EWB No. and EWB Date and write in separate columns . It will look like this -
EWB No. - 111360773355 & EWB Date - 03/08/2021 11:17:00

Can You help me ?

It is possible

  1. First Create a datatable dt1 with columns defined as EWB No and EWB Date

  2. Read the given excel and store in dt2 variable

  3. Use For each row to loop through each row in dt2 [ for each row in dt2]
    inisde it do the following :
    a. Use assign activity to store the EWB No into a variable

    EWB_No=System.Text.RegularExpressions.Regex.Match(row(“EWB.No & Date”).ToString,"^\d{12}").Value.ToString

    b. Use assign activity to store EWB Date

EWB_Date= System.Text.RegularExpressions.Regex.Match(row(“EWB.No & Date”).ToString,"(?<=\d{12}).*").Value.ToString

c. Use add datarow activity to add the below array {EWB_No,EWB_Date} to the dt1 datatable

out of loop, use write range activity to write the dt1 to the excel .

Hope it helps

Nived N
Happy Automation

@NIVED_NAMBIAR , after doing this I get the values of EWB No. but “EWB Date” column is still blank.

I am getting it correctly
Can u share the sample excel data please?

e-Way Bill System.xlsx (24.0 KB)
Here it is. You can see the output in sheet no. 3

Hi @nirmalya.sarkar
here is the solution (4.2 MB)

Nived N

@NIVED_NAMBIAR , Thank you so much. I have some problem regarding the previous problem.
Can I share with you??

Nirmalya Sarkar.

Hi @nirmalya.sarkar
ya sure
better we can open another thread for this

Sure. I have created a new one.

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