Click here to Skip to main content
15,945,939 members
Home / Discussions / Regular Expressions
   

Regular Expressions

 
GeneralRe: I need help with a complex regex Pin
Richard MacCutchan13-Apr-23 5:52
mveRichard MacCutchan13-Apr-23 5:52 
GeneralRe: I need help with a complex regex Pin
jschell14-Apr-23 11:28
jschell14-Apr-23 11:28 
GeneralRe: I need help with a complex regex Pin
Member 1274653217-Apr-23 20:50
Member 1274653217-Apr-23 20:50 
GeneralRe: I need help with a complex regex Pin
Richard MacCutchan17-Apr-23 22:04
mveRichard MacCutchan17-Apr-23 22:04 
QuestionWhat is the regular expression for this string? Pin
Member 1595912122-Mar-23 11:29
Member 1595912122-Mar-23 11:29 
AnswerRe: What is the regular expression for this string? Pin
Richard MacCutchan22-Mar-23 23:12
mveRichard MacCutchan22-Mar-23 23:12 
GeneralRe: What is the regular expression for this string? Pin
k505423-Mar-23 3:52
mvek505423-Mar-23 3:52 
GeneralRe: What is the regular expression for this string? Pin
Richard MacCutchan23-Mar-23 3:55
mveRichard MacCutchan23-Mar-23 3:55 
AnswerRe: What is the regular expression for this string? Pin
jschell23-Mar-23 6:24
jschell23-Mar-23 6:24 
Member 15959121 wrote:
Microsoft.Sql/servers/*.*/databases


You are misusing the asterisk. It matches the preceding element only. which in this case is the forward slash.

Moreover it matches zero or more. Which is probably not what you want.

However you also said...

"Microsoft.Sql/servers/" and "/databases" should be an exact match



So the first attempt at a fix, which is not correct, would look like the following.

(Microsoft.Sql/servers/)?.*/databases


But that is limited then because it does not match the second expression. You might think the following is a good idea but do NOT do this. You should never create a regex in which everything is optional.

(Microsoft.Sql/servers/)?.*(/databases)?


You would need to use an or ('|') with 3 expressions (match first, match last, match all) which to me is way too confusing from the maintenance standpoint.

It is not even clear to me if you have defined your match space. Presuming the following are NOT valid


Microsoft.Sql/servers/xxx
xxx/databases


Then I would do the following (pseudo code)

if match just: Microsoft.Sql/servers
else if match just: /databases
else match: Microsoft.Sql/servers/.*/databases


But additionally note even the above matches the following which is probably not what you want.

Microsoft.Sql/servers///\\&4xz    /databases/servers/databases

AnswerRe: Where to start - need to extract...using regular expression Pin
k505415-Mar-23 10:39
mvek505415-Mar-23 10:39 
QuestionRegular expression to return all keys in a Bibtex file Pin
Member 159423565-Mar-23 5:46
Member 159423565-Mar-23 5:46 
AnswerRe: Regular expression to return all keys in a Bibtex file Pin
Richard Deeming5-Mar-23 21:36
mveRichard Deeming5-Mar-23 21:36 
GeneralRe: Regular expression to return all keys in a Bibtex file Pin
Member 159423566-Mar-23 19:48
Member 159423566-Mar-23 19:48 
AnswerRe: Regular expression to return all keys in a Bibtex file Pin
jschell8-Mar-23 6:57
jschell8-Mar-23 6:57 
QuestionRemove all double quotes not directly preceded or directly followed by a semicolon. Pin
Guus20053-Mar-23 3:55
Guus20053-Mar-23 3:55 
AnswerRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Richard Deeming3-Mar-23 4:05
mveRichard Deeming3-Mar-23 4:05 
GeneralRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Guus20053-Mar-23 5:19
Guus20053-Mar-23 5:19 
GeneralRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
Richard Deeming5-Mar-23 21:27
mveRichard Deeming5-Mar-23 21:27 
AnswerRe: Remove all double quotes not directly preceded or directly followed by a semicolon. Pin
jschell6-Mar-23 6:45
jschell6-Mar-23 6:45 
Questionregex expression for us addresses Pin
jpcodex15321-Feb-23 14:55
jpcodex15321-Feb-23 14:55 
GeneralRe: regex expression for us addresses Pin
PIEBALDconsult21-Feb-23 15:02
mvePIEBALDconsult21-Feb-23 15:02 
GeneralRe: regex expression for us addresses Pin
jpcodex15321-Feb-23 15:25
jpcodex15321-Feb-23 15:25 
GeneralRe: regex expression for us addresses Pin
PIEBALDconsult21-Feb-23 15:30
mvePIEBALDconsult21-Feb-23 15:30 
GeneralRe: regex expression for us addresses Pin
Kenneth Haugland21-Feb-23 18:36
mvaKenneth Haugland21-Feb-23 18:36 
AnswerRe: regex expression for us addresses Pin
jschell22-Feb-23 6:06
jschell22-Feb-23 6:06 

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.