Regular Expressions 101

^start of line

Group 1(R.*\bvsp\b.*?)

Rthe literal R (82₁₀ / 122₈ / 52₁₆) (case sensitive)

.*any character (except for line terminators), repeated any number of times

\ban ASCII word boundary

vspthe literal text vsp (case sensitive)

\ban ASCII word boundary

.*?any character (except for line terminators), repeated any number of times

Group 2(\d+)

\d+a digit, repeated at least once

$end of line

Global pattern flags

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

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

^(R.*\bvsp\b.*?)(\d+)$

New

R1_1 vsp vsp/1 23
R2_1 vsp/2 vsp/3 30
R3_2 vsp/3 vsp/4 50
R3_2 v2 v1 50
C1 vsp/1 vsp 60