Databases
StackOverflow2013
Postsdbo
POMultiline Regex matches first occurance but can't match second
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POMultiline Regex matches first occurance but can't match second
    primarykey
    data
    text
    <p>I have a string in the format below. (I added the markers to get the newlines to show up correctly)</p> <pre><code>-- START BELOW THIS LINE -- 2013-08-28 00:00:00 - Tom Smith (Work notes) Blah blah b;lah blah 2013-08-27 00:00:00 - Tom Smith (Work notes) ZXcZXCZXCZX ZXcZXCZX ZXCZXcZXc ZXCZXC -- END ABOVE THIS LINE -- </code></pre> <p>I am trying to get a regular expression that will allow me to extract the information from the two separate parts of the string.</p> <p>The following expression matches the first portion successfully:</p> <pre><code>^(\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}) - (.*) \\(Work notes\\)\n([\\w\\W]*)(?=\n\n\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2} - .* \\(Work notes\\)\n) </code></pre> <p>I am trying to figure out a way that I can modify it to get the second part of the string. I have tried things like what is below, but it ends up extending the match all the way to the end of the string. It is like it is giving preference to the expression following the OR.</p> <pre><code>^(\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}) - (.*) \\(Work notes\\)\n([\\w\\W]*)(?:(?=\n\n\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2} - .* \\(Work notes\\)\n)|\n\\Z) </code></pre> <p>Any help would be appreciated</p> <p><strong>-- EDIT --</strong></p> <p>Here is a copy of the test program I created to try and get this correct. I also added a 3rd message and my RegEx above breaks in that case.</p> <pre><code>using System; using System.Text.RegularExpressions; namespace RegExTest { class MainClass { public static void Main (string[] args) { string str = "2013-08-28 10:50:13 - Tom Smith (Work notes)\nWhat's up? \nHow you been?\n\n2013-08-19 10:21:03 - Tom Smith (Work notes)\nWork Notes\n\n2013-08-19 10:10:48 - Tom Smith (Work notes)\nGood day\n\n"; var regex = new Regex ("^(\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2}) - (.*) \\(Work notes\\)\n([\\w\\W]*)\n\n(?=\\d{4}-\\d{2}-\\d{2} \\d{2}:\\d{2}:\\d{2} - .* \\(Work notes\\)\n)",RegexOptions.Multiline); foreach (Match match in regex.Matches(str)) { if (match.Success) { for (var i = 0; i &lt; match.Groups.Count; i++) { Console.WriteLine('&gt;'+match.Groups [i].Value); } } } Console.ReadKey(); } } } </code></pre> <p><strong>-- EDIT --</strong></p> <p>Just to make it clear, the data I am trying to extract is the Date and Timestamp (as one item), the name, and the "body" from each "paragraph".</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJason
    1. USJason
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. This table or related slice is empty.
      1. VTUpMod
    1. COCan we see your calling code?
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. USBotonomous
    2. COCould you post the exact code you're using to construct the regex object and to perform the match? You're likely not using the correct flags.
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. USTim Pietzcker
    3. COWhat can appear in the body of the each paragraph, anything ?
      singulars
      1. POMultiline Regex matches first occurance but can't match second
      1. USIbrahim Najjar
 

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