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

[geraldo]

@smrithiraj 

Is the message coming out in Alteryx as an error or is it coming out as a warning?
The warning performs the import correctly but warns that the text contains these characteristics

[danilang · Accepted solution]

Hi @smrithiraj 

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

 

Dan