The proposed spec, and in my experience, says the quotes are optional: > 5. Each field may or may not be enclosed in double quotes (however > some programs, such as Microsoft Excel, do not use double quotes > at all). If fields are not enclosed with double quotes, then > double quotes may not appear inside the fields. For example: > > "aaa","bbb","ccc" CRLF > zzz,yyy,xxx
https://www.ietf.org/rfc/rfc4180.txt I parse this: 06/04/2010,DPC,"'CALL REF.NO. 0552 , TO A/C 03520000",300.00,130117.86,"'Gxxxx J & M","'504237-00001424”, as having these field boundaries: 06/04/2010, DPC, "'CALL REF.NO. 0552 , TO A/C 03520000", 300.00, 130117.86, "'Gxxxx J & M", "'504237-00001424", <empty field> Which is how both Numbers 4.3 and LibreOffice 5.4.1.2 on MacOS read it — so I’m not seeing the problem. I’m guessing OP would like different column splits? Cheers > On 2017-10-16, at 04:27, Ted Burger <[email protected]> wrote: > > A true CSV file looks like: > > "15412049","15552675","CS1 - ""Tools"" to Manage Performance, Enhance > Communication, and Coach for Results","139730","Overall presenter > rating","5","June 20 2017 09:34AM" > > Some simple rules: > Columns are separated by commas. > Columns are enclosed in quotes. > Quotes within a column are double quoted. > > Thanks, > Ted -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "[email protected]" rather than posting to the group. Follow @bbedit on Twitter: <http://www.twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/bbedit.
