Regular Expressions 101

VARIABLEthe literal text VARIABLE (case sensitive)

.*?any character, repeated any number of times

Positive Lookahead(?=VARIABLE|$)

1st AlternativeVARIABLE

VARIABLEthe literal text VARIABLE (case sensitive)

2nd Alternative$

$end of string, or before its final line terminator

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

s modifier: single line. Allows a dot to match line terminators

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

VARIABLE.*?(?=VARIABLE|$)

Test String
New

VARIABLE: GRP1.SGRP1.100:VAR1

Timestamp (LOCAL_TIME),Value
2018-07-18 13:52:09.100,25582
2018-07-18 13:52:49.900,24048
VARIABLE: GRP1.SGRP2.102:VAR1

Timestamp (LOCAL_TIME),Value
2018-07-18 13:52:09.100,25582
2018-07-18 13:52:49.900,24048

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...