C#: How to filter/get value of the specific column in html-table with Regex. Get value between two strings

Question

I want to filter these items that contain "941d3c8a-8d5d-42aa-943e-a07ccaba1629" and get the value inside the of each filtered item. For the first filtered item, the value is " " and for the second the value is "ROBO7 ".

I used regex in C# like below,but it seemed it can't get the correct value. Any help is appreciated.

    Regex regex = new Regex(
      "(]*?>^941d3c8a-8d5d-42aa-943e-a07ccaba1629$<\/TD>)",
    RegexOptions.IgnoreCase
    | RegexOptions.CultureInvariant
    | RegexOptions.IgnorePatternWhitespace
    | RegexOptions.Compiled
    );
MatchCollection ms = regex.Matches(InputText);
int index = 1;
foreach (Match match in ms)
{
 if (match.Groups[2].Value.StartsWith(Search))
   return index;
  index++;
}
return 0;




G1S1990706 
G1:一般支払 
R1:QRなし 
  




RobotAgent1 
2017/09/20 
ＲＯＢＯ７ 
  
2017/11/07 
  

G1S1990716 
G1:一般支払 
01:スキャン済 
  




RobotAgent2
2017/09/20 
ＲＯＢＯ７ 
  
2017/11/13 
ＲＯＢＯ７

oetoni · Accepted Answer

The regex you need for that is this

(?<=941d3c8a-8d5d-42aa-943e-a07ccaba1629">)(.*)(?=)

I will post you C# solution in a bit ;) (updating)

if you need to test the Regex do it here to see validity of conditions. It matches everything in between two strings as per your condition.

here is the simple code example (I'm just printing but you can do whatever you like with it)

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;
using System.Text.RegularExpressions;

namespace test3
{
    class Program
    {

        static void Main(string[] args)
        {

            string createText = System.IO.File.ReadAllText(@"C:\PATH_TO_THE FILE_I_USED\data.txt");

            Regex regex = new Regex("(?<=941d3c8a-8d5d-42aa-943e-a07ccaba1629" >)(.*)(?=<\/ TD >)",
                RegexOptions.IgnoreCase
                | RegexOptions.CultureInvariant
                | RegexOptions.IgnorePatternWhitespace
                | RegexOptions.Compiled
                );

            MatchCollection ms = regex.Matches(createText);

            foreach (Match match in ms)
            {
                Console.WriteLine(match);
            }

            Console.ReadLine();
        }

    }
}

C#: How to filter/get value of the specific column in html-table with Regex. Get value between two strings

Answers (1)

Related Questions