I have test file with the below contents:CREATE TABLE XYZ (ABC INT,CDE CHAR(10),...);Similarly, REPLACE VIEW XYZ (ABC,CDE,EFG);CREATE TABLE XYZ_1 (ABC INT,CDE CHAR(10),...);Similarly, REPLACE VIEW XYZ (ABC,CDE,EFG);Now I want to split this test single file into 2 files: one file with CREATE statement till ;  as file1 and the other file as file2 with REPLACE statement till ;.Can you help me with how to split this, please?
Split a file based on required string
text processing;sed;awk