Groups > comp.sys.mac.apps > #31961

Re: Decent editor for CSV files

From	Jolly Roger <jollyroger@pobox.com>
Newsgroups	comp.sys.mac.apps
Subject	Re: Decent editor for CSV files
Date	2015-09-08 21:23 +0000
Organization	People for the Ethical Treatment of Pirates
Message-ID	<d591u9FlthoU1@mid.individual.net> (permalink)
References	<slrnmunc6l.213c.g.kreme@amelia.local> <fmmck-C3C101.12473906092015@5ad64b5e.bb.sky.com> <d539i1F7kauU2@mid.individual.net> <fmmck-6C27AF.13284008092015@5ad64b5e.bb.sky.com>

Show all headers | View raw

On 2015-09-08, Fred McKenzie <fmmck@aol.com> wrote:
> In article <d539i1F7kauU2@mid.individual.net>,
>  Jolly Roger <jollyroger@pobox.com> wrote:
>
>> > When I used a spreadsheet program, I found that it did not save trailing 
>> > commas where data was blank.  The program that used the CSV files, 
>> > stopped loading when it reached the first line with missing commas.  
>> > Text Editor kept the commas.
>> 
>> Which buggy spreadsheet program was that? I've never seen that behavior
>> from Excel or Numbers.
>
> The spreadsheet is Excel.
>
> I went back and tried again.  There is something buggy about the CSV 
> file.  Excel retains four of five trailing commas at the end of each 
> line for the first half of the data.  The second half it deletes them.
>
> This time the program that uses CSV files (Chirp for programming radio 
> transceivers) imported the file.  There was a format mismatch error 
> message, but data loaded correctly.

Was the original file you opened an Excel file or a CSV file? If it was
a CSV file originally, what are the chances it was already malformed
before you opened (and later saved) it in Excel?

-- 
E-mail sent to this address may be devoured by my ravenous SPAM filter.
I often ignore posts from Google. Use a real news client instead.

JR

Back to comp.sys.mac.apps | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-06 03:18 +0000
  Re: Decent editor for CSV files Jolly Roger <jollyroger@pobox.com> - 2015-09-06 04:03 +0000
    Re: Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-06 04:44 +0000
      Re: Decent editor for CSV files Patty Winter <patty1@wintertime.com> - 2015-09-06 05:15 +0000
        Re: Decent editor for CSV files dempson@actrix.gen.nz (David Empson) - 2015-09-06 22:08 +1200
        Re: Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-06 18:17 +0000
  Re: Decent editor for CSV files Andreas Rutishauser <andreas@macandreas.ch> - 2015-09-06 07:39 +0200
    Re: Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-06 18:20 +0000
  Re: Decent editor for CSV files Fred McKenzie <fmmck@aol.com> - 2015-09-06 12:47 -0400
    Re: Decent editor for CSV files Jolly Roger <jollyroger@pobox.com> - 2015-09-06 16:56 +0000
      Re: Decent editor for CSV files Fred McKenzie <fmmck@aol.com> - 2015-09-08 13:28 -0400
        Re: Decent editor for CSV files Jolly Roger <jollyroger@pobox.com> - 2015-09-08 21:23 +0000
          Re: Decent editor for CSV files Fred McKenzie <fmmck@aol.com> - 2015-09-09 20:27 -0400
            Re: Decent editor for CSV files Jolly Roger <jollyroger@pobox.com> - 2015-09-10 05:54 +0000
  Re: Decent editor for CSV files Louis Wu <louiswu@ringworld.net> - 2015-09-06 17:11 -0700
    Re: Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-07 01:28 +0000
      Re: Decent editor for CSV files Louis Wu <louiswu@ringworld.net> - 2015-09-07 19:53 -0700
        Re: Decent editor for CSV files Lewis <g.kreme@gmail.com.dontsendmecopies> - 2015-09-08 07:47 +0000

csiph-web