Re: BBEdit 12 columns

Out of curiosity and completeness... Have you tried LibreOffice Calc? -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "supp...@barebones.com" rather than posting to the group. Follow @bbedit on Twitter:

Re: BBEdit 12 columns

I don't want to put my bank account statement online, for obvious reasons but if I change '' to '&', it works as expected in Numbers 4.3 otherwise it doesn't. The semicolon throws everything out. -- This is the BBEdit Talk public discussion group. If you have a feature request or would like

Re: BBEdit 12 columns

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 >

Re: BBEdit 12 columns

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

Re: BBEdit 12 columns

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

Re: BBEdit 12 columns

On Oct 15, 2017, at 11:45 AM, jgill wrote: > > Here is a typical line... > > 06/04/2010,DPC,"'CALL REF.NO. 0552 , TO A/C > 0352",300.00,130117.86,"'G J M","'504237-1424", > > The HTML is the giveaway that the CSV is being generated from a HTML >

Re: BBEdit 12 columns

On 10/15/17 at 8:45 AM, joegillespie2...@gmail.com (jgill) wrote: 06/04/2010,DPC,"'CALL REF.NO. 0552 , TO A/C 0352",300.00,130117.86,"'G J M","'504237-1424", As I read that line, the separated columns are: 06/04/2010 DPC "'CALL REF.NO. 0552 , TO A/C 0352" "'G J M"

Re: BBEdit 12 columns

Yes, converting to & is not the issue here. The issue is that the downloaded file won't open correctly in Numbers without processing it in BBEdit and BBEdit won't give me the columnar view by itself, so it is a two step process. Okay, I can live with that and build a suitable script to handle

Re: BBEdit 12 columns

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

Re: BBEdit 12 columns

It won't display it any differently than any other text file. The column support added allows you to copy/paste/delete/move text that makes up a column in a delimited file. There is a variety of conventions for CSV files with the most common looking like: "item1 of record 1","item2 of record

Re: BBEdit 12 columns

Thanks for your help Ted. Yes, Numbers can open CSV files, it just can't open CSV files from *my Bank* correctly. As I said, they are script generated and probably work fine in Excel, but they don't work in Numbers. They are non-standard to all accounts! But anyway, my original question was

Re: BBEdit 12 columns

I just opened a CSV file in Numbers and it worked just fine. Thanks, Ted *** Ted Burger t...@tobsupport.com * www.tobsupport.com > On Oct 15, 2017, at 11:13 AM, jgill wrote: > > I think that the

Re: BBEdit 12 columns

I think that the format of the Bank's CSV has been script generated and is not strictly Excel CSV format. -- This is the BBEdit Talk public discussion group. If you have a feature request or would like to report a problem, please email "supp...@barebones.com" rather than posting to the group.

Re: BBEdit 12 columns

Thanks for the script Ted but it does absolutely nothing to my CSV file. I've tried running it from Script Debugger and from the BBEdit script menu but there are no changes to the file whatsoever. On Sunday, October 15, 2017 at 3:45:25 PM UTC+1, jgill wrote: > > Unless I am completely

Re: BBEdit 12 columns

Here is a script that I keep in Bbedit's script folder to clean up Excel's CSV formatting. I get why Excel does this, but I do not get why they do it even in a TAB delimited file. tell application "BBEdit" activate replace "\" " using " " searching in text 1 of text

BBEdit 12 columns

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