Dear Statalists,
When I use:
Code:
import  delimited   using x.csv, clear delim(",") varn(nonames) encoding("utf-8")
The 509th line in my csv squeezed together in the dta, it looks like this:

Code:
v67

2018 Toys Fair " in HK Convention and Exhibition Fair#2017 Hong Kong international toys &gifts fair,HK#HK,2018.1#2017.10
As you can see the delimiter "," in the line above is not recognized properly somehow (it is supposed to have 3 variables split by commas). Lines before it and after it are all fine.

However, if I save the x.csv as a new csv, the stata command works fine. The line looks neat in the dta:
Code:
v67    v68    v69  

2018 Toys Fair " in HK Convention and Exhibition Fair#2017 Hong Kong international toys &gifts fair    HK#HK    2018.1#2017.10
The x.csv is an output of python. I don't want to save every problematic csv manually as a new csv (I have hundreds of them). I wondered whether there is any other solutions to fix this problem.

Thanks a lot!
Kailin