Path: csiph.com!usenet.pasdenom.info!gegeweb.org!eternal-september.org!feeder.eternal-september.org!mx04.eternal-september.org!.POSTED!not-for-mail
From: sfeam <sfeam@users.sourceforge.net>
Newsgroups: comp.graphics.apps.gnuplot
Subject: Re: Skipping data file with no valid points
Followup-To: comp.graphics.apps.gnuplot
Date: Sun, 04 Nov 2012 15:30:45 -0800
Organization: gnuplot development team
Lines: 39
Message-ID: <k76tr6$nd$1@dont-email.me>
References: <6d2d9f74-3046-4a0d-ba73-fa4c1c833a2d@googlegroups.com>
Reply-To: sfeam@users.sourceforge.net
Mime-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 7Bit
Injection-Date: Sun, 4 Nov 2012 23:30:46 +0000 (UTC)
Injection-Info: mx04.eternal-september.org; posting-host="de68407e1e0278021e2f738a9cf7b10c"; logging-data="749"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1+L9T0Yn/GqSQqUMJuQsbC1"
User-Agent: KNode/4.4.9
Cancel-Lock: sha1:/2fgCAruwMsIHa0wlbcKOFAMwzo=
Xref: csiph.com comp.graphics.apps.gnuplot:1465

erikzweigle@gmail.com wrote:

> Hello,
> 
> I have a single .xlsx file that contains the data I'd like to plot. 
> After reading Gnuplot in Action I only see Janert using .dat & .txt
> file formats.  So, on my mac I 'save as' to .txt 'tab delimited' (as
> opposed to the other two .txt options of MS-DOS & Windows formatted). 
> Then I navigate to the directory of interest in Terminal, launch
> gnuplot and type -- plot "trial.txt" u 1:3 w lp  -- with no luck
> (warning: Skipping data file with no valid points).

gnuplot> set datafile separator '\t'
gnuplot> plot ...

> I tried adding a # to the first line.  I tried alternative .txt
> formats.  

You might have to do that also, depending on the plot commands
you are using. 
	
	Ethan



> I manually re-created the first ten entries in my TextEdit
> app only to find out there is no save as option for .txt files (wtf?).
>  Then I re-created in Xcode which saved it with no file extension BUT
> it plots as expected.  Copying and pasting from the xlsx file into a
> blank Xcode file and saving also works as expected.
> 
> Can someone provide pointers so that I do not have to do this each
> time I want to play with my data?
> 
> In case it was not obvious, I am within my first 4 hours learning
> gnuplot - and Janert's book is great but I'm having trouble getting
> going with real data sets I'd like to analyze.
> 
> Thanks.