I have a line like this in my CSV: “Samsung U600 24″”,”10000003409″,”1″,”10000003427″ Quote next to 24 is used to express inches, while the quote just next to that quote closes the field. I’m reading the line with fgetcsv but the parser makes a mistake and reads the value as: Samsung U600 24″,10000003409″ I tried putting … Read more
Is there any official way to allow a CSV formatted file to allow comments, either on its own line OR at the end of a line? I tried checking wikipedia on this and also RFC 4180 but both do not mention anything which leads me to believe that it’s not part of the file format … Read more
I’ve got a two column CSV with a name and a number. Some people’s name use commas, for example Joe Blow, CFA. This comma breaks the CSV format, since it’s interpreted as a new column. I’ve read up and the most common prescription seems to be replacing that character, or replacing the delimiter, with a … Read more
I am looking for suggestions on how to handle a csv file that is being created, then uploaded by our customers, and that may have a comma in a value, like a company name. Some of the ideas we are looking at are: quoted Identifiers (value “,” values “,”etc) or using a | instead of … Read more
I’ve seen application/csv used and also text/csv. Is there a difference? Does it matter which as long as the request matches something that’s available? Are they interchangeable? 5 s 5
