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>
--- 
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.

Reply via email to