If that file were really in correct Excel CSV format you could do the following. Search for "," quotecommaquote and replace it with a TAB character backslasht. Then goto BBedit Preferences in Editor Defaults and set the "Tab Width" to a bigger number like 10. Now for a file like yours, with somewhat narrow consistent columns, it will be displayed in columns in BBedit.
Thanks, Ted *********************** Ted Burger **************************** [email protected] ********* www.tobsupport.com > 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. > > Anyway, you answered my question. BBEdit can't display columns visually. > > On Sunday, October 15, 2017 at 3:45:25 PM UTC+1, jgill wrote: > Unless I am completely misunderstanding, I thought that BBEdit 12 could open > a CSV file and display it in columns like a spreadsheet. I can find any way > to do this. > > My bank allows me to download a CSV file of my account and Numbers doesn't > know how to handle it because of the quote marks and commas. It must be an > Excel thing, but it doesn't work on a Mac. > > -- > 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.
