Trying to extract table data

djljzenno

Client
Регистрация
26.12.2013
Сообщения
43
Благодарностей
2
Баллы
8
Hello!

You guys have helped me with this one in the past. It seems they have changed it a little and made it not work.

Here are a couple example pages with desired data.

http://en.wikipedia.org/wiki/List_of_Billboard_Hot_100_top_10_singles_in_1990
http://en.wikipedia.org/wiki/List_of_Billboard_Hot_100_top_10_singles_in_1991

I am trying to extract the "Song title" and "Artist" from these pages and place it into a plain text file.

Result example.

Pump up the Jam - Technotronic
Rhythm Nation - Janet Jackson

Some of the data is a link and some is plain text. I can't figure this out. I have tried leftInTab with mixed results as each tag has different info.

Any help would be appreciated.

Thank you!
 
  • Спасибо
Реакции: spyder

StevenCrimmb

Новичок
Регистрация
15.09.2014
Сообщения
8
Благодарностей
1
Баллы
1
Maybe You shoud try using IF.
IF <a found then extract first way, if no <a extract second way
 

djljzenno

Client
Регистрация
26.12.2013
Сообщения
43
Благодарностей
2
Баллы
8
Hmm... let me give that a try. Thanks!
 
  • Спасибо
Реакции: LightWood

drvosjeca

Client
Регистрация
26.10.2011
Сообщения
512
Благодарностей
455
Баллы
63
hey i have made a template for this in order to help you, but i have no clue how to upload stuff now since all this is still in russian :-)

get me on skype and i will give it to you
 

Tobbe

Client
Регистрация
01.08.2013
Сообщения
428
Благодарностей
148
Баллы
43
hey i have made a template for this in order to help you, but i have no clue how to upload stuff now since all this is still in russian :-)
get me on skype and i will give it to you
You can change to English in the bottom left, in the footer of this forum.
I'd also like to take a look at your template. So many different ways to solve it :-)

Don't take StevenCrimmb advice tho, not a good way to work it and may result in countless amount of errors.
 

drvosjeca

Client
Регистрация
26.10.2011
Сообщения
512
Благодарностей
455
Баллы
63
Ohhh... I didnt even see that :-)

No wonder, i wasnt active here for sooo long :D

here you go, i have attached it


PS: I could also merge everything and not add loop, but that was not important here, so i just focused on extracting data
 

Вложения

  • Спасибо
Реакции: Tobbe

Tobbe

Client
Регистрация
01.08.2013
Сообщения
428
Благодарностей
148
Баллы
43
Oh, thought you had a table-template working for all tables and not just this in particular.
+Karma for helping tho :-)
 

drvosjeca

Client
Регистрация
26.10.2011
Сообщения
512
Благодарностей
455
Баллы
63
there is no way you can use same thing for scraping all tables (atleast not when it comes to getting clean data), there is just to much junk around and all that junk is diferent from site to site.

If you are wondering about saving to table, then answer can be easy "CELL RECORDING". :-)

and even cell recording is needed just in case when you dont have same number of columns in every line, or other way around.
 

djljzenno

Client
Регистрация
26.12.2013
Сообщения
43
Благодарностей
2
Баллы
8
Ohhh... I didnt even see that :-)

No wonder, i wasnt active here for sooo long :D

here you go, i have attached it


PS: I could also merge everything and not add loop, but that was not important here, so i just focused on extracting data
Cool.. I will give this a try when I get back home!

Thanks.
 

Кто просматривает тему: (Всего: 2, Пользователи: 0, Гости: 2)