Importing a .csv file with standard stata encoding

[Federico Nutarelli]

Hi all,

I am trying to import a.csv dataframe looking like this (please notice columns new_a1 and new_a2):

Unfortunately, I was not able to attach a datex since I could not import the data properly yet. However, I have attached a sample of the data in .csv format.
When I import the data with import delimited the message appearing (several times acutally) is:

Note: Unmatched quote while processing row 2764799; this can be due to a formatting problem in the file or because a quoted data
    element spans multiple lines. You should carefully inspect your data after importing. Consider using option bindquote(strict) if
    quoted data spans multiple lines or option bindquote(nobind) if quotes are not used for binding data.
(

Since I have ecer adopted the option bindquote and am not sure whether this might solve my problem I would like to as you how you would proceed to import the data.

Thank you

[Martinо Cоmelli]

import delimited ../sampledata.csv, delimiter(comma) bindquote(nobind) varnames(1) stripquote(no) encoding(utf8)

try this, of course you have to specify the correct path.

[Federico Nutarelli]

Thank you for the reply. It worked. The only thing is that, in some cases (not included in the sample), some rows were so long that went on the next line in the .csv. This results in the following

that is it goes on the next line also on the stata file. Is there a way to get around this?

Thank you again