Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You are in luck because C# is one of the few languages (if not the only one) that supports subexpression captures </p> <p><a href="https://msdn.microsoft.com/en-us/library/system.text.regularexpressions.capture(v=vs.110)" rel="nofollow noreferrer">https://msdn.microsoft.com/en-us/library/system.text.regularexpressions.capture(v=vs.110)</a></p> <p>The .NET API can be looked at as follows</p> <pre><code> Matches Groups (most regex engines stop here) Captures (unique for .NET) </code></pre> <p>It's not clear from your question what you want to match exactly but this should get you started. Ask again if you are stuck.</p> <pre><code> string input = "-group1 -group2 "; string pattern = @"(-\S*\W){2}"; foreach (Match match in Regex.Matches(input, pattern)) { Console.WriteLine("Match: {0}", match.Value); for (int groupCtr = 0; groupCtr &lt; match.Groups.Count; groupCtr++) { Group group = match.Groups[groupCtr]; Console.WriteLine(" Group {0}: {1}", groupCtr, group.Value); for (int captureCtr = 0; captureCtr &lt; group.Captures.Count; captureCtr++) Console.WriteLine(" Capture {0}: {1}", captureCtr, group.Captures[captureCtr].Value); } } </code></pre> <p>This ouputs</p> <pre><code>Match: -group1 -group2 Group 0: -group1 -group2 Capture 0: -group1 -group2 Group 1: -group2 Capture 0: -group1 Capture 1: -group2 </code></pre> <p>As you can see (Group 1, Capture 0) and (Group 1, Capture 1) offer the individual captures of a group (and not the last as in most languages)</p> <p>This address I think of what you describe as "to be able to backreference each of the values separately"</p> <p>(You use the term backreference but I don't think you are aiming for a replacement pattern right?)</p>
    singulars
    1. This table or related slice is empty.
    1. PORegular expression to select repeating groups
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USAlex
    1. USbuckley
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PORegular expression to select repeating groups
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. CO+1. I believe this is what he was asking for as well. As an aside, PHP offers this with its ``preg_match_all(...)`` function; using the ``PREG_SET_ORDER`` flag, it returns a multi-dimensional array, the first array containing the first set, the second array containing the second set, etc. (Other flags allow different representations.) My guess is that if .NET and PHP have implemented it, other languages have too.
      singulars
      1. PO
      1. USAndrew Cheong
    2. CO@acheong87 Good comment, I'll add it to the answer to not offend other languages :) I have it from the regexp expert Jan Goyvaerts that .NET was unique on this aspect but I am not active enough on other platforms to back this up.
      singulars
      1. PO
      1. USbuckley
    3. CO@acheong87, that's not the same thing. `preg_match_all()` applies the regex repeatedly and returns the collected results, similar to .NET's `Matches()` method. The OP wants to perform *one* match that will consume the whole string, then break out the individual captures. .NET provides the `CaptureCollection` for that purpose, but PHP has no equivalent.
      singulars
      1. PO
      1. USAlan Moore
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload