Replace content between two words notepad++

Question

do you know how to remove a text between two words in notepad ++

VALUES (1, NULL, NULL,
VALUES (2, NULL, NULL,
VALUES (3, NULL, NULL,

to

VALUES (NULL, NULL,

Answer 1

• Ctrl+H
• Find what: VALUES \(\K[^,]+, ?
• Replace with: LEAVE EMPTY
• check Wrap around
• check Regular expression
• Replace all

Explanation:

VALUES \(   # literally
\K          # forget all we have seen until this position
[^,]+       # 1 or more not comma
, ?         # a comma followed by an optional space

Result for given example:

VALUES (NULL, NULL,
VALUES (NULL, NULL,
VALUES (NULL, NULL,

Screen capture:

Answer 2

resolved

VALUES.*?NULL

VALUES\(NULL

Answer 3

If you just want to remove the first entry from each VALUES clause, then try the following find and replace, in regex mode:

Find:    VALUES \([^,]+,\s*
Replace: VALUES (

Check the demo link below to a working example.

Demo