As I indicated before, the correct column separator in a CSV file is a "," (quotecommaquote) not just a simple , as it appears to be in your sample. When I look at your sample line I only see one instance of "," therefore you should only have two columns in that line.
It would be interesting to see what happens if you were to replace all the , characters with "," just to see what Numbers would do with it then. Thanks, Ted *********************** Ted Burger **************************** [email protected] ********* www.tobsupport.com > On Oct 15, 2017, at 4:07 PM, jgill <[email protected]> wrote: > > It has nothing to do with BBEdit, the downloaded CSV file doesn't parse > correctly in Numbers. The & confuses the column breaks so I only get two > columns which border on the semicolon - but I can fix this by replacing > '&' with '&' in BBEdit. It is the bank that is screwing things up and I > have reported it. > > > -- > 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 > <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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at https://groups.google.com/group/bbedit > <https://groups.google.com/group/bbedit>. -- 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.
