Regular Expressions

Select Case Month
    When 1 Then 'Jan'
    When 2 Then 'Feb'
    When 3 Then 'Mar'
    When 4 Then 'Apr'
    When 5 Then 'May'
    When 6 Then 'Jun'
    When 7 Then 'Jul'
    When 8 Then 'Aug'
    When 9 Then 'Sep'
    When 10 Then 'Oct'
    When 11 Then 'Nov'
    When 12 Then 'Dec'
End + '/' + CAST(Day as varchar(2))
From TableName

string Line = "Ques xx dd\nStack #1:\nTask id #330\nTaskRecord{ccsssew fs sfsdf sdfsdf}";

bool collecting = false;
List<string> collected = new List<string>();
foreach (string line in source-of-text-line-by-line)
{
  if (!collecting && line.StartsWith("Stack"))
  {
    collecting = true;
    collected.Clear();
  }
  if (collecting)
  {
    collected.Add(line);
    if (line.EndsWith("}"))
    {
      collecting = false;
      // Here do whatever processing you want with this set of collected lines
    }
  }
}

Public Function ListItems As List(Of Item)<br />
Dim Result As New List(Of Item)<br />
<br />
Dim items As String = "asd=w2342 asd=12333"<br />
Dim parts() As String = Split(items, " ") 'First off i'm gonna split the items devided by spaces<br />
<br />
For Each part As String In parts<br />
<br />
Dim items() As String = Split(part, "=") 'Second i'm going to split the part into two seperate values<br />
Dim Value1 As String<br />
Dim Value2 As String<br />
<br />
Value1 = items(0)<br />
Value2 = items(1)<br />
<br />
Result.Add(New Item(Value1, Value2) 'Then you can assign these value to a class or something else you want to use this data in...<br />
<br />
Next<br />
<br />
Return Result<br />
<br />
End Sub

Marco Bertschi wrote:

second key can contain an escaped \=

Kornfeld Eliyahu Peter wrote:

Are you sure - isn't it 'second value'?

Kornfeld Eliyahu Peter wrote:

What the separator between one key-value pair to the other?

Kornfeld Eliyahu Peter wrote:

But space also can be in the value part, but not in the key part - Am I right?

Kornfeld Eliyahu Peter wrote:

.NET only extension

^((\\b[^\\s=]+)=(([^=]|\\\\=)+))*$

^((?<key>\b[^\s=]+)=(?<value>([^=]|\\=)+))+$