Too Many Fields Error

smrithiraj

Hi 

I am importing a csv file which has data like below..... The "TEXT" column has the text "within quotes" in inner double quotes.

And because of this, I get an error message as 

Record #1: An unescaped quote was found: "This is "within quotes"

How do I rectify this issue? I have millions of text records in this way.

TEXT,ACTIVE
"This is "within quotes" a text","Y"

Thanks

Smrithi

danilang

Hi @smrithiraj 

Configure your input tool to "Ignore Delimiters in" = None and then trim the resulting extra quotes

Dan

CSV with embedded Quotes.yxmd