External table, rows delimited

 Hallo.

I have a file with this format:

"6295819-976;;;;Ab;;Transcom;TELE ABONNEMANG 2;69179;KARLSKOGA;;B2EN0;3"

"6295819-976;;;;Ab;;Transcom;TELE ABONNEMANG 2;69179;KARLSKOGA;;B2EN0;3"

As you can see, the fields are separated by ';'. A new record is identified with a new line and every record is delimited by ".

How can I wrote an external table declaration that remove the " at the beginning and at the end of the record?

This declaration cannot remove them:

CREATE TABLE KID_MATCH_BOM_EXT

(

  OUP_ID        VARCHAR2(500 CHAR),

  LEGAL_ID      VARCHAR2(12 CHAR),

  OUP_LEGAL_ID  VARCHAR2(12 CHAR),

  NAME_CODE     VARCHAR2(3 CHAR),

  FIRST_NAME    VARCHAR2(64 CHAR),