On Oct 15, 2017, at 11:45 AM, jgill <[email protected]> wrote: > > Here is a typical line... > > 06/04/2010,DPC,"'CALL REF.NO. 0552 , TO A/C > 03520000",300.00,130117.86,"'Gxxxx J & M","'504237-00001424", > > The HTML & is the giveaway that the CSV is being generated from a HTML > file. When I search and replace '&' with '&', the file displays correctly.
I don't understand why having a "&" in the file would be any problem for Numbers. In fact, it is not a problem in experiments I did. If I save your "typical line" as a .csv file, it opens with no problem in Numbers. I tried duplicating the line several times to make a multi-line CSV; still no problem for Numbers (v 4.3). Could there be something else that BBEdit is changing? Perhaps the & code is a non sequitur? I thought about line endings, but I tried all three BBEdit choices in my experiment. Numbers seems agnostic. Unless maybe your file has mixed line endings? -- 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.
