Regex remove rows from csv file

[valentin_vdovin]

Hello! I have difficulties in removing symbols in order to parse csv file as it is not unstructured:

A
a
C9;C12;C15;C18;C21;C24;C27;C30;C33;C36;C39;C42;C45;C48;C51;C54;C57;C60;C63;C66;C69;C72;C75;C78;C81;C84;C87
20654;VA;XX/XX/XX;EN;EN;FS;;1;CHECKED;09-APR-22;09-APR-22;11-APR-22;;2;0;0;CA;SUI;SUI;DBR;123750;TBA;SR;;;;AB
20654;VA;XX/XX/XX;EN;EN;FS;;1;CHECKED;10-APR-22;10-APR-22;12-APR-22;;2;0;0;CS;DCK;SUI;DBRRO;123752;TBS;ST;;;;AB
CF_LOGO;CF_1
;1

Need to be removed:

A
a

and

CF_LOGO;CF_1
;1

Ive tried different ways including replace() function and Text parser, but could not get the right result…
Please help to make a regex for it.

[Mr.Make]

@valentin_vdovin

A
a
C9;C12;C15;C18;C21;C24;C27;C30;C33;C36;C39;C42;C45;C48;C51;C54;C57;C60;C63;C66;C69;C72;C75;C78;C81;C84;C87
20654;VA;XX/XX/XX;EN;EN;FS;;1;CHECKED;09-APR-22;09-APR-22;11-APR-22;;2;0;0;CA;SUI;SUI;DBR;123750;TBA;SR;;;;AB
20654;VA;XX/XX/XX;EN;EN;FS;;1;CHECKED;10-APR-22;10-APR-22;12-APR-22;;2;0;0;CS;DCK;SUI;DBRRO;123752;TBS;ST;;;;AB
CF_LOGO;CF_1
;1

I used split

[valentin_vdovin]

Thanks! Ive tried this but seems like it does not work for some reason. I have a csv which is around 20k rows in it and row qty is increasing each day by around 15-20. Maybe regexp is more suitable solution…

[Mr.Make]

Regrex is more suitable for this case. @samliew Is a king of regrex if hes around.