Vbscript Regular expression for multiline text?

Question

"value:=This customer has one or more active tax exemptions available\.
\n
 \n
Do you want to apply a tax exemption to this transaction\?"

I tried regular expression like "Value:=This.*" but it is not identifying entire text. Please tell me how can i identify entire text using VbScript regular expression by validating only first word in the entire text. Thanks.

Did you mean something like this ? [Demo Here](https://regex101.com/r/5DQeQr/1) — Hackoo, Nov 09 '19 at 02:29
Does this answer your question? [Multiline REGEX using VB Script](https://stackoverflow.com/questions/29364294/multiline-regex-using-vb-script) — user692942, Nov 12 '19 at 09:41

score 0 · Accepted Answer · answered Nov 12 '19 at 01:59

See: How do I match any character across multiple lines in a regular expression?

For example:

Dim s : s = "value:=This customer has one or more active tax exemptions available." & vbCrLf & vbCrLf & "Do you want to apply a tax exemption to this transaction?"
With New RegExp
    .Pattern = "^value:=This(.|\n|\r)*"
    With .Execute(s)
        WScript.Echo .Item(0).Value
    End With
End With

...whose .Pattern starts with (^) 'value:=This', followed by any character (.), line feed (aka, newline) (\n), or carriage return (\r) repeated zero or more times (*).

Output:

value:=This customer has one or more active tax exemptions available.

Do you want to apply a tax exemption to this transaction?

Hope this helps.

Just use `.MultiLine = True`. Ref [Multiline REGEX using VB Script](//stackoverflow.com/a/58816556) — user692942, Nov 12 '19 at 11:31

score 0 · Answer 2 · edited Jun 20 '20 at 09:12

0

I guess,

value:=This\b[\s\S]*

might work OK.

Demo

If you wish to simplify/modify/explore the expression, it's been explained on the top right panel of regex101.com. If you'd like, you can also watch in this link, how it would match against some sample inputs.

edited Jun 20 '20 at 09:12

Community

1
1

answered Nov 12 '19 at 02:14

Emma

1
9
28
53

1

Thanks!! This is exactly what i'm looking for. – Krish V Nov 12 '19 at 22:13

Vbscript Regular expression for multiline text?

2 Answers2

Demo