regex101: PCRE (Legacy) Match Workspace

Group 1(\.)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Positive Lookahead(?=\d+\s*'\s*\)\s*;\s*$)

\d+a digit, repeated at least once

\s*any whitespace character, repeated any number of times

'the literal ' (39₁₀ / 47₈ / 27₁₆)

\s*any whitespace character, repeated any number of times

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

\s*any whitespace character, repeated any number of times

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

\s*any whitespace character, repeated any number of times

$end of line

Global pattern flags

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

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

Search reference

Regular Expression

(\.)(?=\d+\s*'\s*\)\s*;\s*$)

New

INSERT INTO "COMMANDE" VALUES ('10248', 'VINET', '5', TO_DATE('1996-07-04 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-07-16 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '3', 32.38');
INSERT INTO "COMMANDE" VALUES ('10258', 'ERNSH', '1', TO_DATE('1996-07-17 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-08-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-07-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1', 140.51');
INSERT INTO "COMMANDE" VALUES ('10258', 'ERNSH', '1', TO_DATE('1996-07-17 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-08-14 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('1996-07-23 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), '1.', 14051');

Regular Expressions 101

Regular Expression

Substitution