How do I find specific matches using regex and put them in a string array?

Question

I have an HTML file that I'm trying to extract data from. The regex I'm using is

".+?(.+?)&.+?.+?(.+?).+?(.+?).+?"

It works in Python but not in C#. Here's some sample data:


    271
    16/09/2015 05:28 PM
    14.3
    -
    8
    -
    -
    Before dinner
    -
    -
    -



    272
    16/09/2015 02:54 PM
    17.6
    -
    20
    32
    -
    Other
    -
    -
    -



    273
    15/09/2015 11:09 PM
    -
    -
    -
    34
    -
    Before Bed
    -
    -
    -

I'm trying to extract the date from table_row_col2 and the numbers from table_row_col5 and table_row_col6

M. Schena · Accepted Answer

If you know the HTML never changes you can do it like this adding a class Split:

List rows = Split.Extract(htmlString, "class=\"table_row\"", "");
foreach (string row in rows)
{
    string col2 = Split.Extract(row, "class=\"table_row_col2\">", "")[0];
    string col5 = Split.Extract(row, "class=\"table_row_col5\">", "")[0];
    string col6 = Split.Extract(row, "class=\"table_row_col6\">", "")[0];

    Console.WriteLine(col2 + ", " + col5 + ", " + col6);
}

Additional Class Split:

public class Split
{
    public static List Extract(string source, string splitStart, string splitEnd)
    {
        try
        {
            var results = new List();

            string[] start = new string[] { splitStart };
            string[] end = new string[] { splitEnd };
            string[] temp = source.Split(start, StringSplitOptions.None);

            for (int i = 1; i < temp.Length; i++)
            {
                results.Add(temp[i].Split(end, StringSplitOptions.None)[0]);
            }

            return results;
        }
        catch (Exception e)
        {
            throw new Exception(e.Message);
        }
    }
}

How do I find specific matches using regex and put them in a string array?

Answers (1)

Related Questions