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

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

Re: Decent editor for CSV files

Show all headers | View raw

On 2015-09-10, Fred McKenzie <fmmck@aol.com> wrote:
> 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.

I suspect something is wrong with the CSV file before you load it into
Excel. I've used CSV files with Excel for years without issue.

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