Trying to extract table data

[djljzenno]

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!

 

[StevenCrimmb]

Maybe You shoud try using IF.
IF <a found then extract first way, if no <a extract second way

 

[djljzenno]

Hmm... let me give that a try. Thanks!

 

[drvosjeca]

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]

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]

Ohhh... I didnt even see that

No wonder, i wasnt active here for sooo long

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]

Oh, thought you had a table-template working for all tables and not just this in particular.
+Karma for helping tho

 

[drvosjeca]

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]

Ohhh... I didnt even see that

No wonder, i wasnt active here for sooo long

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.