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.
