regex101: PCRE (Legacy) Match Workspace

Positive Lookbehind(?<=^|,)

1st Alternative^

^start of line

2nd Alternative,

,the literal , (44₁₀ / 54₈ / 2C₁₆)

Character Class[789]

7the literal 7 (55₁₀ / 67₈ / 37₁₆)

8the literal 8 (56₁₀ / 70₈ / 38₁₆)

9the literal 9 (57₁₀ / 71₈ / 39₁₆)

Positive Lookahead(?=,|$)

1st Alternative,

,the literal , (44₁₀ / 54₈ / 2C₁₆)

2nd Alternative$

$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

25 tokens

Regular Expression

(?<=^|,)[789](?=,|$)

New

7,30 IN, Ball Valve,9Trunnion,9, CL 900, BW, Body LTCS, Metal Seat, Gear Operated,37,7, NACE MR 0175/ISO 15156 -with extended pup-piece as pipe schedule. VBFW 91Z08.75 IN,77, Gen manu,7 2500, Flanged,7, Body DSS,8, Trim DSS,75, Ball Valve,9, CL 2500,99, RF,Swing Body DSS,789, Trim DSS, Reduced Bore -770343.254.1,9

Substitution

7,30 IN, Ball Valve,9Trunnion,9, CL 900, BW, Body LTCS, Metal Seat, Gear Operated,37,7, NACE MR 0175/ISO 15156 -with extended pup-piece as pipe schedule. VBFW 91Z08.75 IN,77, Gen manu,7 2500, Flanged,7, Body DSS,8, Trim DSS,75, Ball Valve,9, CL 2500,99, RF,Swing Body DSS,789, Trim DSS, Reduced Bore -770343.254.1,9