Data scraping from different positions


#1

how to scrape data from different positions with multiple pages
i want to scrape all mobile numbers and fax numbers
can u help me for scrap
https://targetstudy.com/colleges/private-colleges-in-jaipur.html
thank you in advance


#2

I am not sure if this can be done, because the data position and existence is inconsistent, you can do one thing scrape college name in first column and scrape every other info like address, phone, fax etc in second column then by string manipulations you can get desired result. See sample workflow to scrape like I said

Main.xaml (9.0 KB)


#3

This is i already know.
I want data in different rows
@prankurjoshi


#4

Can you use the little images as an anchor for the data? add them into separate data tables and then merge?


#5

No.
Can u send workflow of this.
@CBlanchard


#6

What have you tried so far? Do you have your workflow you’re trying to work with?


#7

I want to fetch college name , address ,mobile number and fax number from this site
https://targetstudy.com/colleges/private-colleges-in-jaipur.html
but i am able to fetch only College name and address
i also want all mobile number and fax number and insert into excelMain.xaml (16.3 KB)
@CBlanchard


#8

pllzzzzzz anyone help me
@CBlanchard
@prankurjoshi


#9

Main (3).xaml (20.7 KB)

Try that


#10

thank u
but this is not a solution that i want.
Colleges.xlsx (7.3 KB)
this type of excel i want .
@CBlanchard
@prankurjoshi


#11

Play around with the data scrap wizard:

Extract.xlsx (7.7 KB)
Main (3).xaml (22.0 KB)

image


#12

Thank u so much


#13

This is also wrong bcz i want only mobile numbers in third column not fax number Extract.xlsx (7.6 KB)
@CBlanchard
@prankurjoshi
@ranisha