Regular Expressions Discussion Boards

Re: Regular expression date

nagshead_obx9-Oct-14 8:10

nagshead_obx

9-Oct-14 8:10

SQL

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

Re: Regular expression date

George Jonsson9-Oct-14 17:18

George Jonsson

9-Oct-14 17:18

So you want to do this in SQL?

Regex to extact lines of code know the start and ending

susanab17-Apr-14 4:25

susanab

17-Apr-14 4:25

Hi
I would like to extract below data from a file from Stack to "}" , Is the pattern suppose to be like "^Stack #1: ( . ) $}"

Eg Line :
Ques xx dd

Stack #1:

Task id #330

TaskRecord{ccsssew fs sfsdf sdfsdf}

Please Help!!

Re: Regex to extact lines of code know the start and ending

Matt T Heffron17-Apr-14 9:14

Matt T Heffron

17-Apr-14 9:14

It isn't clear what the form of your input to the Regex is.
What you show as "Line" is actually 4 lines (ignoring the blank lines).
So is all of this really in a single string?
I.e.

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

Or are the lines separate strings in an array or list, or are they being read in line-at-a-time?

In any case, the Regex you have is not correct.
The } needs to be before the end of the line!
For the ^ and $ to match beginning and end of line (not beginning and end of the whole string) you need to use Multiline mode.
But to have . also match the \n (end of line) you need to use Singleline mode.
I suppose having both modes set can work (I haven't tried it), but it will sure look strange in the code!!!

So, if your input is separate strings that you are "processing" sequentially, you should do something like:

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
    }
  }
}

[Solved]

Marco Bertschi20-Mar-14 5:10

Marco Bertschi

20-Mar-14 5:10

Me again. RegEx again.

Problem: I need to parse a string which consists out of Key-Value pairs.
Keys are separated from values by a "=". Values can contain a "=", but they must be escaped as "\=".
Example
Key1=Text And escaped\= More stuff\=is here Key2=Value number2

Of course the second key can contain an escaped \=, too. Long story short: Values can be a normal string (any character), except that the equal sign must be escaped.

So far I got (?<=\s|^)([\w ]+)=(\w \\=*)?(?=[ \w=]|[$]) , but it only keeps ordinary Key=value pairs, cutting of at whitespaces.

Edit: Thanks to Richard, who provided a perfectly suitable solution.

I will never again mention that Dalek Dave was the poster of the One Millionth Lounge Post, nor that it was complete drivel.

modified 20-Mar-14 13:03pm.