oracle - Multiple enclosed-by symbols in SQL*Loader -

I am loading a CSV file in the Oracle table. One of the few records has been attached as "abc@xyz.com" and in other records the same field as "code =" abc@xyz.com "" Has been attached as. I just need to load abc@xyz.com .

I used the optionally called '' ' but it does not help in the second case. What is the procedure to specify two symbols in the Optionally called section? Or what are the other ways to get it?

You can trim the leading and indexed single quotes. For example, in which there is a data file:

  "abc@xyz.com" "'abc@xyz.com' 'abc@xyz.com'  

and a control file for a dummy table:

  Load data table T42 Typing New Trimming Newelles (EMAIL CHAR (30) "Trim (both '' 'FROM: EMAIL)" )  

It loads the compromised values:

  select t42 to *; EMAIL ------------ ------------------ abc@xyz.com abc@xyz.com abc@xyz.com  

As you can see , It will load those values ​​which are single quotes, double quotes Ray or both - as long as the singles are within the couple and not the other way.