Creating CSV File That contains Double Quotes With Data
If your fields contain double-quotes as part of their data, the internal quotation marks need to be doubled so that they can be interpreted correctly.
For Example, given the following data:
It should be written in csv file as RollNo, Name, FavoriteSports, Address
12101,Nivetha””” Cricket’”‘” , FootballMylapore chennai
12102, Lavanya, ””” Basketball Cricket “”” , Adyar chennai 12103, Ram, ””” Soccer””” , ”” Hockey””” ,
Gopalapuram chennai
The output will be
