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

Re: Decent editor for CSV files

From	Fred McKenzie <fmmck@aol.com>
Newsgroups	comp.sys.mac.apps
Subject	Re: Decent editor for CSV files
Date	2015-09-08 13:28 -0400
Organization	Aioe.org NNTP Server
Message-ID	<fmmck-6C27AF.13284008092015@5ad64b5e.bb.sky.com> (permalink)
References	<slrnmunc6l.213c.g.kreme@amelia.local> <fmmck-C3C101.12473906092015@5ad64b5e.bb.sky.com> <d539i1F7kauU2@mid.individual.net>

Show all headers | View raw

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.

I tried with Open Office, and 4 of the 5 commas were retained for all 
lines.  It seems that there is no column heading for the field with the 
fifth comma!

Fred

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