VBA RegExp CODE 5019

[PauloCastelo]

Hi folks,

It's my first time here and I'm needing your help.
I'm trying to use a specific regular expression, but when a I try execute, the message shows "Run-time error 5019"
The regular expression I'm using is "(Sumário\n[^]+)".
I done some tests and the error is "^".
How can I done it?

' Execução da Expressão regular
Dim posString As String
Dim newRegEx, newMatch, newMatches
Set newRegEx = New RegExp
newRegEx.pattern = "(Sumario\n[^]+)"


newRegEx.MultiLine = True
newRegEx.IgnoreCase = True
newRegEx.Global = True

Set newMatches = newRegEx.Execute(strTemp)

For Each newMatch In newMatches
RetStr = newMatch.Value
Next
strTemp = RetStr

My idea is take only expressions after word "Sumario".
I used a Macro to take Word Documment to insert in the string (strTemp)
When I tried used newRegEx.pattern = "(Sumario\n[]+)", it's done, but it's not works.

 

[Derek Brown]

Hello and welcome to The Board.
Does the following give you what you want?
sumario([\w\s]*)

 

[Sektor]

What namely you want to extract? Could you show an example?

 

[snb_]

sub M_snb()
  c00="this is an example how to extract text after the word Sumario and nothing else."
  msgbox split(c00,"Sumario")(1)
End Sub

 

[HungQuoc]

newRegEx.pattern = "Sumario" & ".+"

newRegEx.IgnoreCase =False

 

[PauloCastelo]

Yes, I tried. But it takes only next line. I need everthing after expression (too many lines).

 

[PauloCastelo]

sub M_snb()
  c00="this is an example how to extract text after the word Sumario and nothing else."
  msgbox split(c00,"Sumario")(1)
End Sub

snb_,
I need to process with memory, if I shows in the MsgBox it not works.

 

[PauloCastelo]

newRegEx.pattern = "Sumario" & ".+"

newRegEx.IgnoreCase =False

I tried too. It returns only next line.

 

[PauloCastelo]

Yes, I tried. But it takes only next line. I need everthing after expression (too many lines).

I'm using the site regexr.com to make my regular expressions.

I found the used RegExp ("Sumario\n[^]+") there.

 

[wideboydixon]

Looks like a syntax error in the expression to me. Using "^" as the first character in a bracketed expression means "not" but then you don't have any other characters in there. See here:

https://msdn.microsoft.com/en-us/library/1400241x(v=vs.84).aspx

WBD