I have a .csv file which has values like
Abc,3/4"×3/4"
Paper,Blue,2"
Abc 45 xyz 3/4""The issue is when I open it in notepad these values become
"Abc,3/4""×3/4"""
"Paper,Blue,2"""
"Abc 45 xyz 3/4""""These extra double quotes around double quotes cause trouble for me to upload my file in an application which accepts only .csv file.
Is there any way that I can display these values as they are without extra double quotes in notepad?
"Abc,3/4"×3/4""
"Paper,Blue,2""
"Abc 45 xyz 3/4"""1 Answer
There is no real standard for a csv file. RFC4180 is published but "It does not specify an Internet standard of any kind"
When MS Excel (and many other programs) generates a text/csv file, it uses double quotes as a text specifier, so that commas, linefeeds, double quotes within a field will be treated literally.
Short of using VBA, one method would be to
- replace the double quotes with some other character (eg tilde
~); - Generate the csv file
- then use a text-editor (eg notepad, notepad++) on the resultant file to replace the other character with the double-quote,
- then send it to your program that apparently doesn't recognize this feature of csv files.
