I want to extract all occurring text between "CREATE INDEX" and ")" on the following text

I have a text looking like this. But there are thousands of lines to the text. I want to extract text from this and only get the index data.

CREATE INDEX "SCHEMA"."INDEX_NAME1" ON "SCHEMA"."TABNAME1" 
		("COLX" ASC)
		
		COMPRESS NO 
		INCLUDE NULL KEYS ALLOW REVERSE SCANS;

-- DDL Statements for Indexes on Table "CBLOSUAT"."KCR_PRODUCT"

SET SYSIBM.NLS_STRING_UNITS = 'SYSTEM';

CREATE INDEX "SCHEMA"."INDEX_NAME2" ON "SCHEMA"."TABNAME2"  
		("COL1" ASC,
         "COL2" ASC)
		
		COMPRESS NO 
		INCLUDE NULL KEYS ALLOW REVERSE SCANS;

I want something like

CREATE INDEX "SCHEMA"."INDEX_NAME1" ON "SCHEMA"."TABNAME1" 
		("COLX" ASC)

CREATE INDEX "SCHEMA"."INDEX_NAME2" ON "SCHEMA"."TABNAME2"  
		("COL1" ASC,
         "COL2" ASC)

I am getting the text by using "CREATE INDEX[^;]+;" in search mode but now I want to select all of the code and copy it to another text file or create a new text file or delete the rest of the code while keeping what I want.

• <kbd>Ctrl</kbd>+<kbd>H</kbd>
• Find what: ^\h*CREATE INDEX.+?\(.+?\)\R(*SKIP)(*FAIL)|.
• Replace with: LEAVE EMPTY
• TICK Wrap around
• SELECT Regular expression
• TICK . matches newline
• <kbd>Replace all</kbd>

Explanation:

^               # beginning of line
\h*             # 0 or more horizontal spaces
CREATE INDEX    # literally
.+?             # 1 or more any character, not greedy
\(              # opening parenthesis
.+?             # 1 or more any character, not greedy
\)              # closing parenthesis
\R              # any kind of linebreak
(*SKIP)         # forget this match
(*FAIL)         # and considere the match has failed
  |               # OR
.               # any character

Screenshot (before):

Screenshot (after):

I found the answer by the way. I first used "CREATE INDEX[^;]+\Q)\E" in the regex search mode. Then marked it and copy it from the options provided by the notepad++

Steps to mark and copy