Groups > comp.graphics.apps.gnuplot > #1464

Skipping data file with no valid points

Received	by 10.66.75.164 with SMTP id d4mr2665013paw.10.1352071005247; Sun, 04 Nov 2012 15:16:45 -0800 (PST)
Received	by 10.68.141.45 with SMTP id rl13mr1692922pbb.8.1352071005225; Sun, 04 Nov 2012 15:16:45 -0800 (PST)
Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!news.linkpendium.com!news.linkpendium.com!news.snarked.org!newsfeed.news.ucla.edu!usenet.stanford.edu!kt20no31563873pbb.1!news-out.google.com!6ni57209pbd.1!nntp.google.com!kt20no31563872pbb.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.graphics.apps.gnuplot
Date	Sun, 4 Nov 2012 15:16:44 -0800 (PST)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=98.234.174.214; posting-account=KXGM2goAAABCRD2Ngk6bmv3Db6IAfCLl
NNTP-Posting-Host	98.234.174.214
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<6d2d9f74-3046-4a0d-ba73-fa4c1c833a2d@googlegroups.com> (permalink)
Subject	Skipping data file with no valid points
From	erikzweigle@gmail.com
Injection-Date	Sun, 04 Nov 2012 23:16:45 +0000
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
Xref	csiph.com comp.graphics.apps.gnuplot:1464

Show key headers only | View raw

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

I tried adding a # to the first line.  I tried alternative .txt formats.  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.

Back to comp.graphics.apps.gnuplot | Previous | Next — Next in thread | Find similar

Thread

Skipping data file with no valid points erikzweigle@gmail.com - 2012-11-04 15:16 -0800
  Re: Skipping data file with no valid points sfeam <sfeam@users.sourceforge.net> - 2012-11-04 15:30 -0800
    Re: Skipping data file with no valid points erikzweigle@gmail.com - 2012-11-04 16:20 -0800
      Re: Skipping data file with no valid points "Alex van der Spek" <zdoor@xs4all.nl> - 2012-11-06 11:54 +0100
        Re: Skipping data file with no valid points Erik Zweigle <erikzweigle@gmail.com> - 2012-12-06 23:29 -0800

csiph-web