Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From: Jolly Roger <jollyroger@pobox.com>
Newsgroups: comp.sys.mac.apps
Subject: Re: Decent editor for CSV files
Date: 10 Sep 2015 05:54:47 GMT
Organization: People for the Ethical Treatment of Pirates
Lines: 48
Message-ID: <d5ck97Fi2v4U1@mid.individual.net>
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> <d591u9FlthoU1@mid.individual.net> <fmmck-088CC3.20275109092015@5ad64b5e.bb.sky.com>
X-Trace: individual.net Raa25/xAqW4DfUA4OGj3JA9p/vzLFj+LgwBrEOx+6fDD+Dthpz
Cancel-Lock: sha1:xz8f/Tnm81n79iT+1EdcKsCPIXc=
X-Face: _.g>n!a$f3/H3jA]>9pN55*5<`}Tud57>1<n@LQ!aZ7vLO_nWbK~@T'XIS0,oAJcU.qLM dk/j8Udo?O"o9B9Jyx+ez2:B<nx(k3EdHnTvB]'eoVaR495,Rv~/vPa[e^JI+^h5Zk*i`Q;ezqDW< ZFs6kmAJWZjOH\8[$$7jm,Ogw3C_%QM'|H6nygNGhhl+@}n30Nz(^vWo@h>Y%b|b-Y~()~\t,LZ3e up1/bO{=-)
User-Agent: slrn/1.0.1 (Darwin)
Xref: csiph.com comp.sys.mac.apps:31987

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