Click here to Skip to main content
14,920,844 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: RegEx Problem Pin
Kevin Marois19-Jun-12 13:02
professionalKevin Marois19-Jun-12 13:02 
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
MemberChekGuy29-Apr-12 11:48 
AnswerRe: can someone tell me whats wrong with this expression? Pin
egenis29-Apr-12 19:22
Memberegenis29-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
MemberBernhard Hiller6-Mar-12 0:50 
AnswerRe: Either start or not a "d" Pin
Bernhard Hiller6-Mar-12 2:02
MemberBernhard Hiller6-Mar-12 2:02 
QuestionTrying to match non-quoted sections Pin
PIEBALDconsult24-Jan-12 4:30
professionalPIEBALDconsult24-Jan-12 4:30 
Given the name of an SQL table, I am looking to add quotes as necessary (with an loose definition of "necessary"). With SQL Server, the parts of the name should be wrapped in brackets ([ and ]), MySQL uses backticks (`). So, for example:

database.schema.table
database.schema.[table]
database.[schema].table
[database].[schema].table

should all be transformed to:

[database].[schema].[table]


What I have working; is capturing Wrapped and Unwrapped sections separately, wrapping the Unwrapped sections, and joining the sections back together. But it occurred to me that if I could Match only the Unwrapped sections, I could use Replace.

However, I have so far been unsuccessful in my attempts (otherwise I wouldn't be posting). Does anyone out there have an idea of how to do this? I'm thinking it may involve Balancing Groups, but I've never used them before so I'm finding them confusing.

This is not urgent. Big Grin | :-D



Edit: I must have been over-thinking it D'Oh! | :doh: . What I have now is (?<=^|\.)[^\[\]\.]+(?=$|\.)

modified 24-Jan-12 11:00am.

AnswerRe: Trying to match non-quoted sections Pin
Andreas Gieriet7-Apr-12 4:33
professionalAndreas Gieriet7-Apr-12 4:33 
GeneralRe: Trying to match non-quoted sections Pin
PIEBALDconsult7-Apr-12 9:17
professionalPIEBALDconsult7-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
professionalPIEBALDconsult9-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
professionalPIEBALDconsult11-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
professionalPIEBALDconsult11-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
MemberPaladin200020-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
MemberLutosł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
MemberLutosł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 

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.