Regex modify connection string

Question

Lets say I have this SQL Server connection string in C#:

Driver={SQL Server};server=.\sqlexpress;uid=myid;pwd=password;

I would like to remove the Driver= portion of the string, no matter where it appears in the string. So that afterwards it looks like this:

server=.\sqlexpress;uid=myid;pwd=password;

I have been trying Regex for a while with no luck.

Could you put that regex you tried in your question?

Jerry
– Jerry

2014-01-19 14:13:20 +00:00
Commented Jan 19, 2014 at 14:13 — Jerry
– Jerry, Commented Jan 19, 2014 at 14:13

SLaks · Accepted Answer · 2014-01-19 14:13:22Z

2

You're looking for the OdbcConnectionStringBuilder class, which will parse this for you.

answered Jan 19, 2014 at 14:13

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

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

Comments

Sergey Kalinichenko · Accepted Answer · 2014-01-19 14:14:31Z

2

You can do it like this:

res = Regex.Replace(connStr, "Driver=[{][^}]*[}];", "");

For your string it produces

server=.\sqlexpress;uid=myid;pwd=password;

Demo on ideone.

answered Jan 19, 2014 at 14:14

Sergey Kalinichenko

729k85 gold badges1.2k silver badges1.6k bronze badges

Comments

Casimir et Hippolyte · Accepted Answer · 2014-01-19 14:42:25Z

1

You can use this:

string pattern = @"\bDriver=[^;]+;";
string replacement = "";
Regex rgx = new Regex(pattern);
string result = rgx.Replace(input, replacement);

edited Jan 19, 2014 at 14:42

answered Jan 19, 2014 at 14:14

Casimir et Hippolyte

90k5 gold badges102 silver badges131 bronze badges

5 Comments

Casimir et Hippolyte Over a year ago

@RoyiNamir: indeed, line breaks are included. Is it a problem?

Neil Weicher Over a year ago

Doh! I was making it too complex. Thanks!

Wagner DosAnjos Over a year ago

This breaks if Driver is at the end of the string without the ; separator. server=.\sqlexpress;uid=myid;pwd=password;Driver={SQL Server}

Casimir et Hippolyte Over a year ago

@wdosanjos: in this specific case you can use (?:;|$) instead of ;

Casimir et Hippolyte Over a year ago

To be more waterproof, you can replace \b with (?<=^|[;\n])[^\S\n]*

BlackBear · Accepted Answer · 2014-01-19 14:15:42Z

0

Might not work as it stands but I hope you get the idea:

string result = string.Join(";", connectionString
    .Split(';')
    .Where(p => !p.StartsWith('Driver'))

As a side note, I find it amazing that there are four completely different solutions ;)

answered Jan 19, 2014 at 14:15

BlackBear

23.1k10 gold badges52 silver badges90 bronze badges

Comments

Aaron Palmer · Accepted Answer · 2014-01-19 15:42:46Z

0

To expand on the answer SLaks gave:

[TestMethod]
public void TestMethod1()
{
    var connStr = "Driver={SQL Server};server=.\\sqlexpress;uid=myid;pwd=password;";
    var builder = new DbConnectionStringBuilder();
    builder.ConnectionString = connStr;
    builder.Remove("Driver");
    connStr = builder.ConnectionString;
    Assert.AreEqual("server=.\\sqlexpress;uid=myid;pwd=password", connStr);
}

answered Jan 19, 2014 at 15:42

Aaron Palmer

9,0309 gold badges52 silver badges78 bronze badges

Collectives™ on Stack Overflow

Regex modify connection string

5 Answers 5

Comments

Comments

5 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

5 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related