Extract part of string from a string?

Question

Hi i am having a problem with my application i want a part of string from a string.The situation is i am having a string variable named as stringData it stores following values:

IP Address         Hardware Address         Lease expiration                Type
192.168.1.2        00-23-8B-87-9A-6B        Mon Jan 02 01:14:00 2006        Dynamic
192.168.1.3        F8-F7-D3-00-03-80        Mon Jan 02 01:14:00 2006        Dynamic 
192.168.1.4        F8-F7-D3-00-9C-C4        Mon Jan 02 01:14:00 2006        Dynamic 
192.168.1.5        F0-DE-F1-33-9C-C4        Mon Jan 02 01:14:00 2006        Dynamic

I just want Hardware Address starting with F8-F7-D3-00. I am using a substring method now but i am getting only one matched hardware address but there might be a possibility of multiple strings as in above e.g and i want all of them.I am using C#. Any help would be highly appreciable.

//int index = stringData.IndexOf("F8-F7-D3-00"); // //string sub = stringData.Substring(index, 17); // //Console.WriteLine(sub); — TheSpy
– TheSpy, Commented Apr 1, 2014 at 8:46
Is the whole table stored in a single string variable? Are the columns separated by tab or spaces? — Arvin Yorro
– Arvin Yorro, Commented Apr 1, 2014 at 8:47

Sabuj Hassan · Accepted Answer · 2014-04-01 08:57:06Z

1

Try this one:

string pattern = @"(F8-F7-D3-00\S+)";
string input = "IP Address         Hardware Address         Lease expiration                Type\n"+
    "192.168.1.2        00-23-8B-87-9A-6B        Mon Jan 02 01:14:00 2006        Dynamic\n"+
    "192.168.1.3        F8-F7-D3-00-03-80        Mon Jan 02 01:14:00 2006        Dynamic \n"+
    "192.168.1.4        F8-F7-D3-00-9C-C4        Mon Jan 02 01:14:00 2006        Dynamic \n"+
    "192.168.1.5        F0-DE-F1-33-9C-C4        Mon Jan 02 01:14:00 2006        Dynamic";

MatchCollection matches = Regex.Matches(input, pattern);
foreach (Match match in matches)
{
   Console.WriteLine("Hardware Address: {0}", match.Groups[1].Value);
}

answered Apr 1, 2014 at 8:57

Sabuj Hassan

39.7k14 gold badges83 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TaW · Accepted Answer · 2014-04-01 08:47:49Z

0

Split the string into separate lines first like this:

        string[] linesep = new string[] {"\r\n"};
        string[] dataLines = stringData .Split(linesep, StringSplitOptions.RemoveEmptyEntries);

Then apply your Substring method to each:

foreach (line in dataLines)
{
    if (line.Contains(yourIPstring)
    // .. do your stuff
}

You may have to change the line separators.

answered Apr 1, 2014 at 8:47

TaW

54.6k8 gold badges74 silver badges115 bronze badges

Comments

Michael Mairegger · Accepted Answer · 2014-04-01 08:52:42Z

0

You can easily use Regular expression

var file = File.ReadAllText(@"....\Input.txt");

Regex r = new Regex("F8-F7-D3-00(-[0-9A-F]{2}){2}");
var matches = r.Matches(file);
foreach (Match m in matches)
{
    Console.WriteLine(m.Value);
}

answered Apr 1, 2014 at 8:52

Michael Mairegger

7,35133 silver badges44 bronze badges

Comments

bkardol · Accepted Answer · 2014-04-01 08:56:51Z

0

If the string contains tabs you could split it by '/t' (a horizontal tab).

string hardwareAddresses = stringData.split('/t').ToList().Where((item, index) => index % 4 == 1);

hardwareAddresses will then contain an array of hardware addresses

answered Apr 1, 2014 at 8:56

bkardol

1,2681 gold badge20 silver badges32 bronze badges

Collectives™ on Stack Overflow

Extract part of string from a string?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related