Regex Extraction Help Please

[djljzenno]

Hello!

I am having a problem extracting the data from these pages as the tags change throughout the page.

Can someone help me with the regex?

http://en.wikipedia.org/wiki/List_of_Billboard_Hot_100_number-one_singles_of_1990

What I need is the "Song" and "Artist" text only so that I can save to csv file.

Example data output desired:

"Another Day in Paradise","Phil Collins"
"How Am I Supposed to Live Without You","Michael Bolton"

Thanks for your help!

 

[LexxWork]

use links like
http://en.m.wikipedia.org/w/index.php?mobileaction=toggle_view_mobile&title=List_of_Billboard_Hot_100_number-one_singles_of_1998
this code saves all needed data to the [project directory] + "\" + title + ".csv"

string table =  string.Join("\r\n", 
    instance.ActiveTab.FindElementsByXPath("//table[@class='wikitable'][2]/tbody/tr").Elements
    .Where(e=>e.GetChildren(false).Count == 4)
    .Skip(1)
    .Select<HtmlElement, string>(e=>{
        var t = e.GetChildren(false).Elements;
        return (t[1].GetAttribute("innertext").Replace("\r\n", "").Replace(" \"", "\"").Replace("\" ", "\"")
                    +","+
           "\""+t[2].GetAttribute("innertext").Replace("\r\n", "")+"\""
        );
    }).ToArray());

if(table == "") return "error";
string title = System.Text.RegularExpressions.Regex.Match(instance.ActiveTab.URL, "(?<=title=)[^&]+").Value;
System.IO.File.WriteAllText(project.Directory+"\\"+title+".csv", table, Encoding.UTF8);

example of data returned

"Something About the Way You Look Tonight"/"Candle in the Wind 1997","Elton John"
"Truly Madly Deeply","Savage Garden"
"Together Again","Janet"
"Nice & Slow","Usher"
"My Heart Will Go On","Céline Dion"
"Gettin' Jiggy wit It ”,"Will Smith"
"All My Life","K-Ci & JoJo"
"Too Close","Next"
"My All","Mariah Carey"
"Too Close","Next"
"The Boy Is Mine","Brandy and Monica"
"I Don't Want to Miss a Thing","Aerosmith"
"The First Night","Monica"
"One Week","Barenaked Ladies"
"The First Night","Monica"
"Doo Wop (That Thing)","Lauryn Hill"
"Lately","Divine"
"I'm Your Angel","R. Kelly and Céline Dion"

 

[djljzenno]

That works beautifully LexxWork!!

Thank you!

use links like
http://en.m.wikipedia.org/w/index.php?mobileaction=toggle_view_mobile&title=List_of_Billboard_Hot_100_number-one_singles_of_1998
this code saves all needed data to the [project directory] + "\" + title + ".csv"

string table =  string.Join("\r\n",
    instance.ActiveTab.FindElementsByXPath("//table[@class='wikitable'][2]/tbody/tr").Elements
    .Where(e=>e.GetChildren(false).Count == 4)
    .Skip(1)
    .Select<HtmlElement, string>(e=>{
        var t = e.GetChildren(false).Elements;
        return (t[1].GetAttribute("innertext").Replace("\r\n", "").Replace(" \"", "\"").Replace("\" ", "\"")
                    +","+
           "\""+t[2].GetAttribute("innertext").Replace("\r\n", "")+"\""
        );
    }).ToArray());

if(table == "") return "error";
string title = System.Text.RegularExpressions.Regex.Match(instance.ActiveTab.URL, "(?<=title=)[^&]+").Value;
System.IO.File.WriteAllText(project.Directory+"\\"+title+".csv", table, Encoding.UTF8);

example of data returned

 

[djljzenno]

How would I do this page also please? I tried changing your code but I am not exactly sure what does what. If there are variables like cell positions that would be helpful.

Thank you!

http://en.m.wikipedia.org/wiki/List_of_Billboard_Hot_100_top_10_singles_in_1980