Thread: Need help with a regular expression, please?

I have , "(`password_hash`(255),`email`(255))" and want to get "password_hash,email".

So far my best guess has been:
string pattern = @"[`(\(0-9\))]";
string pkey = Regex.Replace(tokens[offset], pattern, "");

but there is another case where I have "(`field4`)" and it comes out to be "field" when I need it to be "field4".

Any help would be appreciated. I'm terrible with regex.

Hmm... well the fields you want are wrapped in quotes so `[^`]*` should match all the fields.

Originally Posted by whiteflags

Hmm... well the fields you want are wrapped in quotes so `[^`]*` should match all the fields.

Thanks! That helped. My solution is fugly, but it works:

Code:

string pattern = @"`[^`]*`";
                        MatchCollection pkeys = Regex.Matches("(`field4`(255),`email`(255))", pattern);
                        string pkey = "";
                        bool first = true;
                        StringBuilder sb1 = new StringBuilder();
                        foreach (Match pk in pkeys)
                        {
                            GroupCollection gc = pk.Groups;
                            if (!first) sb1.Append(",");
                            first = false;
                            sb1.Append(gc[0].Value.Replace("`",""));
                        }
                        pkey = sb1.ToString(); //"field4,email"