C# Regular Expression find the string after a string

Question

I have a connection string

"User ID=abc;Password=pwd;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRDREPTQ)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PRRQ)))"

I want to use regular expression to parse out the host "PRDREPTQ" value only. Can anybody help me write the pattern?

This tool helped me a lot check it out debuggex.com

Alex Denysenko
– Alex Denysenko

2014-03-13 18:04:04 +00:00
Commented Mar 13, 2014 at 18:04 — Alex Denysenko
– Alex Denysenko, Commented Mar 13, 2014 at 18:04

Lloyd · Accepted Answer · 2014-03-13 18:04:23Z

2

Easiest solution:

\(HOST=(.*?)\)

For example:

enter image description here

So in C#:

Match match = Regex.Match(inputString,@"\(HOST=(.*?)\)",RegexOptions.IgnoreCase | RegexOptions.Singleline);
string host_value = match.Groups[1].Value;

answered Mar 13, 2014 at 18:04

Lloyd

29.7k5 gold badges89 silver badges100 bronze badges

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

1 Comment

Honghao Over a year ago

That is exactly what I need. Do appreciate it!

Amit Joki · Accepted Answer · 2014-03-13 18:04:40Z

0

Use this:

Regex HOST=(\w+)

And capture the first group

string testString = "User ID=abc;Password=pwd;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=PRDREPTQ)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PRRQ)))";
var match= Regex.Match(testString, @"HOST=(\w+)");
Console.WriteLine(match.Groups[1]);

answered Mar 13, 2014 at 18:04

Amit Joki

59.4k7 gold badges80 silver badges96 bronze badges

Collectives™ on Stack Overflow

C# Regular Expression find the string after a string

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related