I am trying to write regex in notepad++ to only select a specific word DATE and not select any combination of words having DATE e.g. UPDATE, CONSOLIDATE or words with prefix with underscore or any other combination.
CREATE TABLE PERSON (
FIRST_NAME VARCHAR2;
LAST_NAME VARCHAR2;
INSERT_DATE DATE;
UPDATE_TIME DATE;
LASTEUPDATED DATE;
CONSOLIDATE DATE;
CHECKED_DATE DATE;
);
I used this pattern (UPDATE) but it gets UPDATE_TIME as well.
The result should look something like this:
DATE
DATE
DATE
DATE
DATE
Any suggestions or thoughts?
>Solution :
You may place word boundaries \b around DATE to only match it as a standalone word:
Find: \bDATE\b
Replace: DATETIME