Click here to Skip to main content
15,881,413 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
AnswerRe: RegEx Problem Pin
AspDotNetDev19-Jun-12 13:35
protectorAspDotNetDev19-Jun-12 13:35 
Questioncan someone tell me whats wrong with this expression? Pin
ChekGuy29-Apr-12 11:48
ChekGuy29-Apr-12 11:48 
AnswerRe: can someone tell me whats wrong with this expression? Pin
egenis29-Apr-12 19:22
egenis29-Apr-12 19:22 
AnswerRe: can someone tell me whats wrong with this expression? Pin
Peter_in_278029-Apr-12 19:46
professionalPeter_in_278029-Apr-12 19:46 
QuestionEither start or not a "d" Pin
Bernhard Hiller6-Mar-12 0:50
Bernhard Hiller6-Mar-12 0:50 
AnswerRe: Either start or not a "d" Pin
Bernhard Hiller6-Mar-12 2:02
Bernhard Hiller6-Mar-12 2:02 
QuestionTrying to match non-quoted sections Pin
PIEBALDconsult24-Jan-12 4:30
mvePIEBALDconsult24-Jan-12 4:30 
AnswerRe: Trying to match non-quoted sections Pin
Andreas Gieriet7-Apr-12 4:33
professionalAndreas Gieriet7-Apr-12 4:33 
Are you looking for this?
C#
string sql = @"database.schema.table
database.schema.[table]
database.[schema].table
[database].[schema].table
 
should all be transformed to:
 
[database].[schema].[table]
";
string pattern = @"(?:\[?(\w+)\]?)?\.\[?(\w+)\]?";
Func<Match, string> replace = m =>
    (m.Groups[1].Success ? "[" + m.Groups[1].Value + "]" : "") + ".[" + m.Groups[2].Value + "]";
Console.WriteLine("{0}", Regex.Replace(sql, pattern, m=>replace(m)));

GeneralRe: Trying to match non-quoted sections Pin
PIEBALDconsult7-Apr-12 9:17
mvePIEBALDconsult7-Apr-12 9:17 
GeneralRe: Trying to match non-quoted sections Pin
Andreas Gieriet7-Apr-12 11:04
professionalAndreas Gieriet7-Apr-12 11:04 
GeneralRe: Trying to match non-quoted sections Pin
PIEBALDconsult9-Apr-12 18:03
mvePIEBALDconsult9-Apr-12 18:03 
GeneralRe: Trying to match non-quoted sections Pin
Andreas Gieriet10-Apr-12 9:59
professionalAndreas Gieriet10-Apr-12 9:59 
GeneralRe: Trying to match non-quoted sections Pin
PIEBALDconsult11-Apr-12 3:10
mvePIEBALDconsult11-Apr-12 3:10 
GeneralRe: Trying to match non-quoted sections Pin
Andreas Gieriet11-Apr-12 13:11
professionalAndreas Gieriet11-Apr-12 13:11 
GeneralRe: Trying to match non-quoted sections Pin
PIEBALDconsult11-Apr-12 14:45
mvePIEBALDconsult11-Apr-12 14:45 
GeneralRe: Trying to match non-quoted sections Pin
Andreas Gieriet11-Apr-12 21:52
professionalAndreas Gieriet11-Apr-12 21:52 
GeneralRe: Trying to match non-quoted sections Pin
Luc Pattyn7-Apr-12 9:43
sitebuilderLuc Pattyn7-Apr-12 9:43 
GeneralRe: Trying to match non-quoted sections Pin
Andreas Gieriet7-Apr-12 10:39
professionalAndreas Gieriet7-Apr-12 10:39 
QuestionSomething I just learned, with IP addresses Pin
Paladin200020-Jan-12 6:42
Paladin200020-Jan-12 6:42 
AnswerRe: Something I just learned, with IP addresses Pin
Andreas Gieriet7-Apr-12 13:10
professionalAndreas Gieriet7-Apr-12 13:10 
QuestionHow to regex this Pin
Lutosław17-Jan-12 12:05
Lutosław17-Jan-12 12:05 
AnswerRe: How to regex this Pin
Peter_in_278017-Jan-12 12:37
professionalPeter_in_278017-Jan-12 12:37 
GeneralRe: How to regex this Pin
Lutosław17-Jan-12 12:55
Lutosław17-Jan-12 12:55 
AnswerRe: How to regex this Pin
Peter_in_278018-Jan-12 17:41
professionalPeter_in_278018-Jan-12 17:41 
GeneralRe: How to regex this Pin
Lutosław19-Jan-12 4:12
Lutosław19-Jan-12 4:12 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.