Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Decent editor for CSV files

Show all headers | View raw

In article <d591u9FlthoU1@mid.individual.net>,
 Jolly Roger <jollyroger@pobox.com> wrote:

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

The file was created using the Macintosh version of the Chirp program, 
and exported as CSV.  Yes it may be malformed!  I don't think I have a 
program that can see non-printing characters.  Nothing unusual shows up 
in Word, TextEdit, TextWrangler or Safari.

If I import the Excel CSV file into Chirp, only the first half loads and 
errors are reported.  I tried opening the Excel CSV in TextEdit and 
adding back all the missing commas.  Chirp loads the resulting file with 
no errors.

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