C#

Kevin Marois wrote:

RegEx

var expression = @"(?:(?'Key'\S+): (?'Value'.*?)) ";
Match match = Regex.Match(Line, expression,RegexOptions.IgnoreCase);

if (match.Success)
{
    string key = match.Groups[1].Value;

}

Kevin Marois wrote:

Never done RegEx, so I'm totally unsure how to code it.

public static Regex regex = new Regex(
      "(?:(?'Key'\\S+): (?'Value'.*?))",
    RegexOptions.RightToLeft
    | RegexOptions.CultureInvariant
    | RegexOptions.Compiled
    );

regex.Match(Line, expression);

MatchCollection matches = regex.Matches(expression);
foreach (Match match in matches)
{
  Console.WriteLine("Key: {0} - Value: {1}", match.Groups["Key"], match.Groups["Value"]);
}

MatchCollection matches = regex.Matches(Line);

var Line = "Dev: 0 Model: TOSHIBA MK3265GSX   Serial: 20FDF20WS  FW: GJ002H STW: 0 MaxLBA: 625142447 FDESUPPORTED: 0 PREBOOT: 0 DRIVETRUSTENABLED: 0 DRIVETRUSTSUPPORTED: 0 w128: 41 FULLFW: GJ002H SERVOFW:  SDLSUPPORTED: 1 PLATFORM: 0 SAFE: 1 DSTTIMEOUT: 103 ISBOOTORSYSTEM: 1";
var WordToFind = "Model";

Regex regex = new Regex("(?:(?'Key'\\S+): (?'Value'.*?))",
                    RegexOptions.RightToLeft |
                    RegexOptions.CultureInvariant |
                    RegexOptions.Compiled);

MatchCollection matches = regex.Matches(WordToFind);

foreach (Match match in matches)
{
    Console.WriteLine("Key: {0} - Value: {1}", match.Groups["Key"], match.Groups["Value"]);
}

Kevin Marois wrote:

EDIT] - Never mind. I'm stupid. I changed it to...
 

MatchCollection matches = regex.Matches(Line);

Dan_K wrote:

I do not want the Excel grid or cells to be part, just the chart output that is inserted in the worksheet. Thanks.

Bastard Programmer from Hell