C#: Regex TRIM on the fly?

I'm reading 'live' server log information (before written to log.txt) into an MS-SQL database. All is well and performance is outstanding. I would like to improve my Regex parsing to clean-up my SQL data for easier processing. For instance,

This Regex will find any 'Port' number from 1 - 999999 contained within ( and ).......
($(\d{1,6})$) = (1) to (999999) Port Addresses

Although, I would like to 'Trim' off the ( and ) before it is written to the database so the port looks like 25 and not (25).

Q. How can I painlessly perform the 'Trim' task in Regex

kvnsdr

Asked: 2004-09-15

Advertise Here

1 Solution

LVL 1

CrazyIvan007Commented: 2004-09-15

Regex.Replace(strLog, @"$(\d{1,6})$", "$1");

LVL 1

kvnsdrAuthor Commented: 2004-09-15

I'm not quite sure how to cleanly implement your code with my existing code as follows:

string pattern4 = @"($(\d{1,6})$)";
Regex r4 = new Regex(pattern4, RegexOptions.Compiled);
Match Port = r4.Match(str);

LVL 10

eternal_21Commented: 2004-09-15

I think what you are looking for is:

string pattern4 = @"((?<=$)(\d{1,6})(?=$))";
Regex r4 = new Regex(pattern4, RegexOptions.Compiled);
Match Port = r4.Match("asdasads (123123) asdasd");

LVL 19

drichardsCommented: 2004-09-15

Actually, your regex has already done that for you - you have groups defined in your regex expression.
Try:

string port = r4.Match.Groups[r4.Groups.Count-1]; // add .Value to the end for completeness ...
string port = r4.Match.Groups[r4.Groups.Count-1].Value;

Also, your regex is overkill, you don't need the forst parens. This just makes the entire match another group, which is redundant. You will get the same result with:

string pattern4 = @"$(\d{1,6})$";

But without a redundant group.

LVL 10

eternal_21Commented: 2004-09-15

Oh yeah, as drichards said you don't need the outside brackets... so:

string pattern4 = @"(?<=$)\d{1,6}(?=$)";

Would work just fine.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

C#: Regex TRIM on the fly?

Join & Write a Comment Already a member? Login.

Featured Post