From MAILER-DAEMON Fri Dec 29 19:01:07 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eV4aJ-0006kc-8l
	for mharc-pspp-users@gnu.org; Fri, 29 Dec 2017 19:01:07 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:56114)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eV4aH-0006kB-9O
	for pspp-users@gnu.org; Fri, 29 Dec 2017 19:01:06 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eV4aD-0000xQ-EL
	for pspp-users@gnu.org; Fri, 29 Dec 2017 19:01:05 -0500
Received: from omr-m008e.mx.aol.com ([204.29.186.7]:41890)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <maffydoit@aol.com>) id 1eV4aD-0000un-7k
	for pspp-users@gnu.org; Fri, 29 Dec 2017 19:01:01 -0500
Received: from mtaomg-mad01.mx.aol.com (mtaomg-mad01.mx.aol.com
	[172.26.221.207])
	by omr-m008e.mx.aol.com (Outbound Mail Relay) with ESMTP id
	60CD238000B3
	for <pspp-users@gnu.org>; Fri, 29 Dec 2017 19:01:00 -0500 (EST)
Received: from core-mbd03h.mail.aol.com (core-mbd03.mail.aol.com
	[172.27.110.13])
	by mtaomg-mad01.mx.aol.com (OMAG/Core Interface) with ESMTP id
	0FDCD38000082
	for <pspp-users@gnu.org>; Fri, 29 Dec 2017 19:01:00 -0500 (EST)
Received: from 77.111.246.16 by webjasstg-vaa04.srv.aolmail.net (10.96.25.7)
	with HTTP (WebMailUI); Fri, 29 Dec 2017 19:00:59 -0500
Date: Fri, 29 Dec 2017 19:00:59 -0500
From: someone <maffydoit@aol.com>
To: pspp-users@gnu.org
Message-Id: <160a4b8c1da-c0b-191b@webjasstg-vaa04.srv.aolmail.net>
Subject: reading csv data set
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_8351_164263101.1514592059866"
X-MB-Message-Source: WebUI
X-MB-Message-Type: User
X-Mailer: JAS STD
X-Originating-IP: [77.111.246.16]
x-aol-global-disposition: G
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com;
	s=20150623; t=1514592060;
	bh=Fg3ghSRETLLpxxQTACh6CZ6TwQeoqEuF5TrwlwrCjC4=;
	h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type;
	b=euvGRvBEgIJpmtR0WUxzqr94mw6Ov8HnF9bkqh+TgToXZ76CdWRZQKAgZcLm6+rVW
	mdp3YzMFGDwpk8Qiasoew0nc68ahzIwLSi2GtJ2grq8QSZyjNbG1bqgvL7U240q+zB
	s3ALzj30kwAYKGCuPW//qsZn6C0KSFFK0bcW+/Es=
x-aol-sid: 3039ac1addcf5a46d73c7ef8
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.4.x-2.6.x [generic]
	[fuzzy]
X-Received-From: 204.29.186.7
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sat, 30 Dec 2017 00:01:06 -0000

------=_Part_8351_164263101.1514592059866
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi all


I'm trying to read in a data set, in csv. I also have xls and ods versions,=
 all here
https://sites.google.com/site/gsocialchange/datasets



All the files I'm looking at are versions of the pd_data_cia data set.


I -have- imported the ods version, but when I try to import the csv version=
, I just get blank. I go to file, import data, go to my directory, and all =
the files are listed. I click on pd_data_cia.cvs, and then on the upper lef=
t of the screen, where it says select file to import, I cannot select any o=
f the options.


I am using pspp version 1.0.1-g818227, downloaded a couple of days ago from=
 here
https://sourceforge.net/projects/pspp4windows/

I'm on windows, 64 bit operating system, I think windows 10.


I also tried using the command line, and, well, not doing it right, perhaps=
 someone can help? These are the lines I tried



get data
  / type=3Dtxt=20
  / file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data\testdata\PD_data_ci=
a.csv=E2=80=99
  / arrangement=3Ddelimited
  / firstcase=3D2
  / delimiters=3D","



Thanks


Gene Shackman



------=_Part_8351_164263101.1514592059866
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<font color=3D'black' size=3D'2' face=3D'arial'>Hi all
<div><br>
</div>

<div>I'm trying to read in a data set, in csv. I also have xls and ods vers=
ions, all here</div>

<div>https://sites.google.com/site/gsocialchange/datasets<br>
</div>

<div><br>
</div>

<div>All the files I'm looking at are versions of the pd_data_cia data set.=
</div>

<div><br>
</div>

<div>I -have- imported the ods version, but when I try to import the csv ve=
rsion, I just get blank. I go to file, import data, go to my directory, and=
 all the files are listed. I click on pd_data_cia.cvs, and then on the uppe=
r left of the screen, where it says select file to import, I cannot select =
any of the options.</div>

<div><br>
</div>

<div>I am using pspp version&nbsp;1.0.1-g818227, downloaded a couple of day=
s ago from here</div>

<div>https://sourceforge.net/projects/pspp4windows/<br>
</div>

<div>I'm on windows, 64 bit operating system, I think windows 10.</div>

<div><br>
</div>

<div>I also tried using the command line, and, well, not doing it right, pe=
rhaps someone can help? These are the lines I tried</div>

<div><br>
</div>

<div>
<div>get data</div>

<div>&nbsp; / type=3Dtxt&nbsp;</div>

<div>&nbsp; / file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data\testdata\=
PD_data_cia.csv=E2=80=99</div>

<div>&nbsp; / arrangement=3Ddelimited</div>

<div>&nbsp; / firstcase=3D2</div>

<div>&nbsp; / delimiters=3D","</div>
</div>

<div><br>
</div>

<div>Thanks</div>

<div><br>
</div>

<div>Gene Shackman</div>

<div><br>
</div>
</font>
------=_Part_8351_164263101.1514592059866--


From MAILER-DAEMON Sat Dec 30 10:05:44 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eVIhk-0007ED-6d
	for mharc-pspp-users@gnu.org; Sat, 30 Dec 2017 10:05:44 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:41477)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <public.ftr@free.fr>) id 1eVIhe-0007Ch-Ne
	for pspp-users@gnu.org; Sat, 30 Dec 2017 10:05:40 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <public.ftr@free.fr>) id 1eVIha-0001Sv-KH
	for pspp-users@gnu.org; Sat, 30 Dec 2017 10:05:38 -0500
Received: from smtp05.smtpout.orange.fr ([80.12.242.127]:55966
	helo=smtp.smtpout.orange.fr)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <public.ftr@free.fr>) id 1eVIha-0001Nb-7P
	for pspp-users@gnu.org; Sat, 30 Dec 2017 10:05:34 -0500
Received: from [192.168.1.136] ([83.112.150.151]) by mwinf5d28 with ME
	id sF5X1w0013GE9fX03F5XWF; Sat, 30 Dec 2017 16:05:31 +0100
X-ME-Helo: [192.168.1.136]
X-ME-Auth: ZnJhbmtfdGhvbWFzQG9yYW5nZS5mcg==
X-ME-Date: Sat, 30 Dec 2017 16:05:31 +0100
X-ME-IP: 83.112.150.151
Subject: Re: reading csv data set
To: pspp-users@gnu.org
References: <160a4b8c1da-c0b-191b@webjasstg-vaa04.srv.aolmail.net>
From: ftr public <public.ftr@free.fr>
Message-ID: <1b89ffa0-43ff-6b8b-75f7-28c8babc6762@free.fr>
Date: Sat, 30 Dec 2017 16:04:34 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
	Thunderbird/52.5.0
MIME-Version: 1.0
In-Reply-To: <160a4b8c1da-c0b-191b@webjasstg-vaa04.srv.aolmail.net>
Content-Type: multipart/alternative;
	boundary="------------6476E8379A0EB15006BC2F56"
Content-Language: en-US
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x [fuzzy]
X-Received-From: 80.12.242.127
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sat, 30 Dec 2017 15:05:40 -0000

This is a multi-part message in MIME format.
--------------6476E8379A0EB15006BC2F56
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi Gene,

I also tried to import the csv data file and got into difficulties.

How did you import the ods file ? Can you send the syntax ?

What is funny is that the country data set has no case, i.e. country, names.

Regards,

ftr


On 30/12/2017 01:00, someone wrote:
> Hi all
>
> I'm trying to read in a data set, in csv. I also have xls and ods 
> versions, all here
> https://sites.google.com/site/gsocialchange/datasets
>
> All the files I'm looking at are versions of the pd_data_cia data set.
>
> I -have- imported the ods version, but when I try to import the csv 
> version, I just get blank. I go to file, import data, go to my 
> directory, and all the files are listed. I click on pd_data_cia.cvs, 
> and then on the upper left of the screen, where it says select file to 
> import, I cannot select any of the options.
>
> I am using pspp version 1.0.1-g818227, downloaded a couple of days ago 
> from here
> https://sourceforge.net/projects/pspp4windows/
> I'm on windows, 64 bit operating system, I think windows 10.
>
> I also tried using the command line, and, well, not doing it right, 
> perhaps someone can help? These are the lines I tried
>
> get data
>   / type=txt
>   / file=’C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv’
>   / arrangement=delimited
>   / firstcase=2
>   / delimiters=","
>
> Thanks
>
> Gene Shackman
>
>
>
> _______________________________________________
> Pspp-users mailing list
> Pspp-users@gnu.org
> https://lists.gnu.org/mailman/listinfo/pspp-users


--------------6476E8379A0EB15006BC2F56
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi Gene,</p>
    <p>I also tried to import the csv data file and got into
      difficulties.</p>
    <p>How did you import the ods file ? Can you send the syntax ? <br>
    </p>
    <p>What is funny is that the country data set has no case, i.e.
      country, names.</p>
    <p>Regards,</p>
    <p>ftr<br>
    </p>
    <br>
    <div class="moz-cite-prefix">On 30/12/2017 01:00, someone wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:160a4b8c1da-c0b-191b@webjasstg-vaa04.srv.aolmail.net"><font
        size="2" face="arial" color="black">Hi all
        <div><br>
        </div>
        <div>I'm trying to read in a data set, in csv. I also have xls
          and ods versions, all here</div>
        <div><a class="moz-txt-link-freetext" href="https://sites.google.com/site/gsocialchange/datasets">https://sites.google.com/site/gsocialchange/datasets</a><br>
        </div>
        <div><br>
        </div>
        <div>All the files I'm looking at are versions of the
          pd_data_cia data set.</div>
        <div><br>
        </div>
        <div>I -have- imported the ods version, but when I try to import
          the csv version, I just get blank. I go to file, import data,
          go to my directory, and all the files are listed. I click on
          pd_data_cia.cvs, and then on the upper left of the screen,
          where it says select file to import, I cannot select any of
          the options.</div>
        <div><br>
        </div>
        <div>I am using pspp version 1.0.1-g818227, downloaded a couple
          of days ago from here</div>
        <div><a class="moz-txt-link-freetext" href="https://sourceforge.net/projects/pspp4windows/">https://sourceforge.net/projects/pspp4windows/</a><br>
        </div>
        <div>I'm on windows, 64 bit operating system, I think windows
          10.</div>
        <div><br>
        </div>
        <div>I also tried using the command line, and, well, not doing
          it right, perhaps someone can help? These are the lines I
          tried</div>
        <div><br>
        </div>
        <div>
          <div>get data</div>
          <div>  / type=txt </div>
          <div>  /
            file=’C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv’</div>
          <div>  / arrangement=delimited</div>
          <div>  / firstcase=2</div>
          <div>  / delimiters=","</div>
        </div>
        <div><br>
        </div>
        <div>Thanks</div>
        <div><br>
        </div>
        <div>Gene Shackman</div>
        <div><br>
        </div>
      </font>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Pspp-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Pspp-users@gnu.org">Pspp-users@gnu.org</a>
<a class="moz-txt-link-freetext" href="https://lists.gnu.org/mailman/listinfo/pspp-users">https://lists.gnu.org/mailman/listinfo/pspp-users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>

--------------6476E8379A0EB15006BC2F56--


From MAILER-DAEMON Sat Dec 30 12:49:10 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eVLFu-0000St-QJ
	for mharc-pspp-users@gnu.org; Sat, 30 Dec 2017 12:49:10 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:58287)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVLFs-0000SE-0S
	for pspp-users@gnu.org; Sat, 30 Dec 2017 12:49:09 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVLFo-0000nW-Jx
	for pspp-users@gnu.org; Sat, 30 Dec 2017 12:49:08 -0500
Received: from omr-m016e.mx.aol.com ([204.29.186.16]:57056)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <maffydoit@aol.com>) id 1eVLFo-0000mT-CK
	for pspp-users@gnu.org; Sat, 30 Dec 2017 12:49:04 -0500
Received: from mtaomg-aak01.mx.aol.com (mtaomg-aak01.mx.aol.com [172.27.2.227])
	by omr-m016e.mx.aol.com (Outbound Mail Relay) with ESMTP id
	62B243800090; Sat, 30 Dec 2017 12:49:03 -0500 (EST)
Received: from core-mbd03h.mail.aol.com (core-mbd03.mail.aol.com
	[172.27.110.13])
	by mtaomg-aak01.mx.aol.com (OMAG/Core Interface) with ESMTP id
	0689E38000083; Sat, 30 Dec 2017 12:49:03 -0500 (EST)
Received: from 77.111.245.12 by webjasstg-vab15.srv.aolmail.net (10.96.25.82)
	with HTTP (WebMailUI); Sat, 30 Dec 2017 12:49:02 -0500
Date: Sat, 30 Dec 2017 12:49:02 -0500
From: someone <maffydoit@aol.com>
To: public.ftr@free.fr, pspp-users@gnu.org
Message-Id: <160a88a9484-c0d-c8d@webjasstg-vab15.srv.aolmail.net>
In-Reply-To: <1b89ffa0-43ff-6b8b-75f7-28c8babc6762@free.fr>
Subject: reading csv data set
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_3903_229279453.1514656142468"
X-MB-Message-Source: WebUI
X-MB-Message-Type: User
X-Mailer: JAS STD
X-Originating-IP: [77.111.245.12]
x-aol-global-disposition: G
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com;
	s=20150623; t=1514656143;
	bh=ohgSxU1awHX5zfHsBLzfd+j1c92kM6oQTv1L2Tn+co0=;
	h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type;
	b=Gr4gNy8j8s8Ftk+gQbQyENUuNOPoZPcusmd366a0SAhnJud0AwAwT57NjYSqGFf3+
	cxodcoLAvo5pNBA1MHNg/eIJwP7/yafltYdN4TfhmW/RAquTtxA8HtHS5IdejU26To
	JqoXOmi6EYEDjVFr2s0Q7zZf0cenzHh2QnZwGVYg=
x-aol-sid: 3039ac1b02e35a47d18f7c08
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.4.x-2.6.x [generic]
	[fuzzy]
X-Received-From: 204.29.186.16
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sat, 30 Dec 2017 17:49:09 -0000

------=_Part_3903_229279453.1514656142468
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Hi


Thanks for the response. I imported the ods file through the gui interface.=
 That is,=20
file
import data
went to my directory, clicked on the ods data set
next
got the screen importing spreadsheet data
next
apply


I did notice that, when I read the ods file, pspp, in the output viewer, sh=
owed this


get data
 /type=3Dods
 /file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"
 /sheet=3Dindex 1
 /readnames=3Don
 /cellrange=3Drange "a1:al236".



So to try to read the csv file, I tried this



get data
  / type=3Dtxt=20
  / file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv"
  / arrangement=3Ddelimited
  / firstcase=3D2
  / delimiters=3D",".


now, only one error:
.19: error: Syntax error at end of command: expecting '/'.

Does that help?


Thanks


Gene




-----Original Message-----
From: ftr public <public.ftr@free.fr>
To: pspp-users <pspp-users@gnu.org>
Sent: Sat, Dec 30, 2017 10:05 am
Subject: Re: reading csv data set


   =20
Hi Gene,
   =20
I also tried to import the csv data file and got into      difficulties.
   =20
How did you import the ods file ? Can you send the syntax ?=20
   =20
   =20
What is funny is that the country data set has no case, i.e.      country, =
names.
   =20
Regards,
   =20
ftr
   =20
   =20
   =20
On 30/12/2017 01:00, someone wrote:
   =20
   =20
Hi all       =20

       =20
       =20
I'm trying to read in a data set, in csv. I also have xls          and ods =
versions, all here
       =20
https://sites.google.com/site/gsocialchange/datasets
       =20
       =20

       =20
       =20
All the files I'm looking at are versions of the          pd_data_cia data =
set.
       =20

       =20
       =20
I -have- imported the ods version, but when I try to import          the cs=
v version, I just get blank. I go to file, import data,          go to my d=
irectory, and all the files are listed. I click on          pd_data_cia.cvs=
, and then on the upper left of the screen,          where it says select f=
ile to import, I cannot select any of          the options.
       =20

       =20
       =20
I am using pspp version 1.0.1-g818227, downloaded a couple          of days=
 ago from here
       =20
https://sourceforge.net/projects/pspp4windows/
       =20
       =20
I'm on windows, 64 bit operating system, I think windows          10.
       =20

       =20
       =20
I also tried using the command line, and, well, not doing          it right=
, perhaps someone can help? These are the lines I          tried
       =20

       =20
       =20
         =20
get data
         =20
  / type=3Dtxt=20
         =20
  /            file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data\testdata=
\PD_data_cia.csv=E2=80=99
         =20
  / arrangement=3Ddelimited
         =20
  / firstcase=3D2
         =20
  / delimiters=3D","
       =20
       =20

       =20
       =20
Thanks
       =20

       =20
       =20
Gene Shackman
       =20

       =20
           =20
     =20
     =20
     =20
_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users

   =20
   =20
 =20
_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
https://lists.gnu.org/mailman/listinfo/pspp-users


------=_Part_3903_229279453.1514656142468
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<font color=3D'black' size=3D'2' face=3D'arial'>Hi
<div><br>
</div>

<div>Thanks for the response. I imported the ods file through the gui inter=
face. That is,&nbsp;</div>

<div>file</div>

<div>import data</div>

<div>went to my directory, clicked on the ods data set</div>

<div>next</div>

<div>got the screen importing spreadsheet data</div>

<div>next</div>

<div>apply</div>

<div><br>
</div>

<div>I did notice that, when I read the ods file, pspp, in the output viewe=
r, showed this</div>

<div><br>
</div>

<div>get data</div>

<div>&nbsp;/type=3Dods</div>

<div>&nbsp;/file=3D"<span style=3D"font-size: small;">C:\Users\Owner\Docume=
nts\icaap\data\testdata\PD_data_cia.ods"</span><br>
&nbsp;/sheet=3Dindex 1</div>

<div>&nbsp;/readnames=3Don</div>

<div>&nbsp;/cellrange=3Drange "a1:al236".</div>

<div><br>
</div>

<div><br>
So to try to read the csv file, I tried this</div>

<div><br>
</div>

<div>
<div>get data</div>

<div>&nbsp; / type=3Dtxt&nbsp;</div>

<div>&nbsp; / file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_=
cia.csv"</div>

<div>&nbsp; / arrangement=3Ddelimited</div>

<div>&nbsp; / firstcase=3D2</div>

<div>&nbsp; / delimiters=3D",".</div>

<div><br>
</div>

<div>now, only one error:</div>

<div>.19: error: Syntax error at end of command: expecting '/'.</div>
<br>
Does that help?</div>

<div><br>
</div>

<div>Thanks</div>

<div><br>
</div>

<div>Gene</div>

<div><br>
<br>
<br>

<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original Message-----<br>
From: ftr public &lt;public.ftr@free.fr&gt;<br>
To: pspp-users &lt;pspp-users@gnu.org&gt;<br>
Sent: Sat, Dec 30, 2017 10:05 am<br>
Subject: Re: reading csv data set<br>
<br>


<div id=3D"AOLMsgPart_1.2_05b1c8af-8e88-4b0d-869f-2caaa981ec41">

<div text=3D"#000000" bgcolor=3D"#FFFFFF" class=3D"aolReplacedBody">
   =20
<div>Hi Gene,</div>

   =20
<div>I also tried to import the csv data file and got into
      difficulties.</div>

   =20
<div>How did you import the ods file ? Can you send the syntax ? <br>

    </div>

   =20
<div>What is funny is that the country data set has no case, i.e.
      country, names.</div>

   =20
<div>Regards,</div>

   =20
<div>ftr<br>

    </div>

    <br>

   =20
<div class=3D"aolmail_moz-cite-prefix">On 30/12/2017 01:00, someone wrote:<=
br>

    </div>

    <blockquote cite=3D"about:blank"><font size=3D"2" face=3D"arial" color=
=3D"black">Hi all
       =20
<div><br>

        </div>

       =20
<div>I'm trying to read in a data set, in csv. I also have xls
          and ods versions, all here</div>

       =20
<div><a class=3D"aolmail_moz-txt-link-freetext" target=3D"_blank" rel=3D"no=
opener noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=
=3D"https://sites.google.com/site/gsocialchange/datasets">https://sites.goo=
gle.com/site/gsocialchange/datasets</a><br>

        </div>

       =20
<div><br>

        </div>

       =20
<div>All the files I'm looking at are versions of the
          pd_data_cia data set.</div>

       =20
<div><br>

        </div>

       =20
<div>I -have- imported the ods version, but when I try to import
          the csv version, I just get blank. I go to file, import data,
          go to my directory, and all the files are listed. I click on
          pd_data_cia.cvs, and then on the upper left of the screen,
          where it says select file to import, I cannot select any of
          the options.</div>

       =20
<div><br>

        </div>

       =20
<div>I am using pspp version&nbsp;1.0.1-g818227, downloaded a couple
          of days ago from here</div>

       =20
<div><a class=3D"aolmail_moz-txt-link-freetext" target=3D"_blank" rel=3D"no=
opener noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=
=3D"https://sourceforge.net/projects/pspp4windows/">https://sourceforge.net=
/projects/pspp4windows/</a><br>

        </div>

       =20
<div>I'm on windows, 64 bit operating system, I think windows
          10.</div>

       =20
<div><br>

        </div>

       =20
<div>I also tried using the command line, and, well, not doing
          it right, perhaps someone can help? These are the lines I
          tried</div>

       =20
<div><br>

        </div>

       =20
<div>
         =20
<div>get data</div>

         =20
<div>&nbsp; / type=3Dtxt&nbsp;</div>

         =20
<div>&nbsp; /
            file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data\testdata\PD=
_data_cia.csv=E2=80=99</div>

         =20
<div>&nbsp; / arrangement=3Ddelimited</div>

         =20
<div>&nbsp; / firstcase=3D2</div>

         =20
<div>&nbsp; / delimiters=3D","</div>

        </div>

       =20
<div><br>

        </div>

       =20
<div>Thanks</div>

       =20
<div><br>

        </div>

       =20
<div>Gene Shackman</div>

       =20
<div><br>

        </div>

      </font>
      <br>

      <fieldset class=3D"aolmail_mimeAttachmentHeader"></fieldset>
      <br>

      <pre>_______________________________________________
Pspp-users mailing list
<a class=3D"aolmail_moz-txt-link-abbreviated" target=3D"_blank" rel=3D"noop=
ener noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=3D=
"mailto:Pspp-users@gnu.org">Pspp-users@gnu.org</a>
<a class=3D"aolmail_moz-txt-link-freetext" target=3D"_blank" rel=3D"noopene=
r noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=3D"ht=
tps://lists.gnu.org/mailman/listinfo/pspp-users">https://lists.gnu.org/mail=
man/listinfo/pspp-users</a>
</pre>
    </blockquote>
    <br>

 =20

</div>

</div>

_______________________________________________<br>
Pspp-users mailing list<br>
Pspp-<a removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=3D"mailto:u=
sers@gnu.org">users@gnu.org</a><br>
<a removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href=3D"https://lists=
.gnu.org/mailman/listinfo/pspp-users" target=3D"_blank">https://lists.gnu.o=
rg/mailman/listinfo/pspp-users</a><br>
</div>
</div>
</font>
------=_Part_3903_229279453.1514656142468--


From MAILER-DAEMON Sat Dec 30 16:09:07 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eVONP-0007K1-LH
	for mharc-pspp-users@gnu.org; Sat, 30 Dec 2017 16:09:07 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:37638)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <public.ftr@free.fr>) id 1eVONN-0007JW-35
	for pspp-users@gnu.org; Sat, 30 Dec 2017 16:09:06 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <public.ftr@free.fr>) id 1eVONI-0001Eh-2L
	for pspp-users@gnu.org; Sat, 30 Dec 2017 16:09:05 -0500
Received: from smtp06.smtpout.orange.fr ([80.12.242.128]:48479
	helo=smtp.smtpout.orange.fr)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <public.ftr@free.fr>) id 1eVONH-0001Cv-Ha
	for pspp-users@gnu.org; Sat, 30 Dec 2017 16:08:59 -0500
Received: from [192.168.1.136] ([83.112.150.151]) by mwinf5d82 with ME
	id sM8x1w0053GE9fX03M8xk6; Sat, 30 Dec 2017 22:08:58 +0100
X-ME-Helo: [192.168.1.136]
X-ME-Auth: ZnJhbmtfdGhvbWFzQG9yYW5nZS5mcg==
X-ME-Date: Sat, 30 Dec 2017 22:08:58 +0100
X-ME-IP: 83.112.150.151
Subject: Re: reading csv data set
To: someone <maffydoit@aol.com>, pspp-users@gnu.org
References: <160a88a9484-c0d-c8d@webjasstg-vab15.srv.aolmail.net>
From: ftr public <public.ftr@free.fr>
Message-ID: <29b2965c-92e9-6294-f0eb-2a5c85a8dac3@free.fr>
Date: Sat, 30 Dec 2017 22:08:00 +0100
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:52.0) Gecko/20100101
	Thunderbird/52.5.0
MIME-Version: 1.0
In-Reply-To: <160a88a9484-c0d-c8d@webjasstg-vab15.srv.aolmail.net>
Content-Type: multipart/alternative;
	boundary="------------AFE054F5C5CA7EF6B38E463A"
Content-Language: en-US
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.6.x [fuzzy]
X-Received-From: 80.12.242.128
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sat, 30 Dec 2017 21:09:06 -0000

This is a multi-part message in MIME format.
--------------AFE054F5C5CA7EF6B38E463A
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

I imported the ods data file with the following syntax:

GET DATA /TYPE=ODS
/FILE="(file path)\pd_data_cia.ods"
/READNAMES=ON.

and it worked.

I also imported the csv file into Libreoffice Calc to see the data. When 
using the comma as a field delimiter I realised that the function of 
integrating several field delimiter into a single one made that the 
imported data and the column headers did not fit : there were too few 
data columns. Only when you stop the last functionality the importation 
went as expected.

Thanks for the idea of a direct importation of ods files into PSPP of 
which I was unaware.

- ftr

On 30/12/2017 18:49, someone wrote:
> Hi
>
> Thanks for the response. I imported the ods file through the gui 
> interface. That is,
> file
> import data
> went to my directory, clicked on the ods data set
> next
> got the screen importing spreadsheet data
> next
> apply
>
> I did notice that, when I read the ods file, pspp, in the output 
> viewer, showed this
>
> get data
>  /type=ods
>  /file="C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"
>  /sheet=index 1
>  /readnames=on
>  /cellrange=range "a1:al236".
>
>
> So to try to read the csv file, I tried this
>
> get data
>   / type=txt
>   / file="C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv"
>   / arrangement=delimited
>   / firstcase=2
>   / delimiters=",".
>
> now, only one error:
> .19: error: Syntax error at end of command: expecting '/'.
>
> Does that help?
>
> Thanks
>
> Gene
>
>
>
> -----Original Message-----
> From: ftr public <public.ftr@free.fr>
> To: pspp-users <pspp-users@gnu.org>
> Sent: Sat, Dec 30, 2017 10:05 am
> Subject: Re: reading csv data set
>
> Hi Gene,
> I also tried to import the csv data file and got into difficulties.
> How did you import the ods file ? Can you send the syntax ?
> What is funny is that the country data set has no case, i.e. country, 
> names.
> Regards,
> ftr
>
> On 30/12/2017 01:00, someone wrote:
>
>     Hi all
>
>     I'm trying to read in a data set, in csv. I also have xls and ods
>     versions, all here
>     https://sites.google.com/site/gsocialchange/datasets
>
>     All the files I'm looking at are versions of the pd_data_cia data set.
>
>     I -have- imported the ods version, but when I try to import the
>     csv version, I just get blank. I go to file, import data, go to my
>     directory, and all the files are listed. I click on
>     pd_data_cia.cvs, and then on the upper left of the screen, where
>     it says select file to import, I cannot select any of the options.
>
>     I am using pspp version 1.0.1-g818227, downloaded a couple of days
>     ago from here
>     https://sourceforge.net/projects/pspp4windows/
>     I'm on windows, 64 bit operating system, I think windows 10.
>
>     I also tried using the command line, and, well, not doing it
>     right, perhaps someone can help? These are the lines I tried
>
>     get data
>       / type=txt
>       /
>     file=’C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv’
>       / arrangement=delimited
>       / firstcase=2
>       / delimiters=","
>
>     Thanks
>
>     Gene Shackman
>
>
>
>     _______________________________________________
>     Pspp-users mailing list
>     Pspp-users@gnu.org
>     https://lists.gnu.org/mailman/listinfo/pspp-users
>
>
> _______________________________________________
> Pspp-users mailing list
> Pspp-users@gnu.org
> https://lists.gnu.org/mailman/listinfo/pspp-users


--------------AFE054F5C5CA7EF6B38E463A
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <p>Hi,</p>
    <p>I imported the ods data file with the following syntax:</p>
    <p>GET DATA /TYPE=ODS<br>
      /FILE="(file path)\pd_data_cia.ods"<br>
      /READNAMES=ON.<br>
    </p>
    and it worked.<br>
    <br>
    I also imported the csv file into Libreoffice Calc to see the data.
    When using the comma as a field delimiter I realised that the
    function of integrating several field delimiter into a single one
    made that the imported data and the column headers did not fit :
    there were too few data columns. Only when you stop the last
    functionality the importation went as expected.<br>
     <br>
    Thanks for the idea of a direct importation of ods files into PSPP
    of which I was unaware.<br>
    <br>
    - ftr<br>
    <br>
    <div class="moz-cite-prefix">On 30/12/2017 18:49, someone wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:160a88a9484-c0d-c8d@webjasstg-vab15.srv.aolmail.net"><font
        size="2" face="arial" color="black">Hi
        <div><br>
        </div>
        <div>Thanks for the response. I imported the ods file through
          the gui interface. That is, </div>
        <div>file</div>
        <div>import data</div>
        <div>went to my directory, clicked on the ods data set</div>
        <div>next</div>
        <div>got the screen importing spreadsheet data</div>
        <div>next</div>
        <div>apply</div>
        <div><br>
        </div>
        <div>I did notice that, when I read the ods file, pspp, in the
          output viewer, showed this</div>
        <div><br>
        </div>
        <div>get data</div>
        <div> /type=ods</div>
        <div> /file="<span style="font-size: small;">C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"</span><br>
           /sheet=index 1</div>
        <div> /readnames=on</div>
        <div> /cellrange=range "a1:al236".</div>
        <div><br>
        </div>
        <div><br>
          So to try to read the csv file, I tried this</div>
        <div><br>
        </div>
        <div>
          <div>get data</div>
          <div>  / type=txt </div>
          <div>  /
            file="C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv"</div>
          <div>  / arrangement=delimited</div>
          <div>  / firstcase=2</div>
          <div>  / delimiters=",".</div>
          <div><br>
          </div>
          <div>now, only one error:</div>
          <div>.19: error: Syntax error at end of command: expecting
            '/'.</div>
          <br>
          Does that help?</div>
        <div><br>
        </div>
        <div>Thanks</div>
        <div><br>
        </div>
        <div>Gene</div>
        <div><br>
          <br>
          <br>
          <div
            style="font-family:arial,helvetica;font-size:10pt;color:black">-----Original
            Message-----<br>
            From: ftr public <a class="moz-txt-link-rfc2396E" href="mailto:public.ftr@free.fr">&lt;public.ftr@free.fr&gt;</a><br>
            To: pspp-users <a class="moz-txt-link-rfc2396E" href="mailto:pspp-users@gnu.org">&lt;pspp-users@gnu.org&gt;</a><br>
            Sent: Sat, Dec 30, 2017 10:05 am<br>
            Subject: Re: reading csv data set<br>
            <br>
            <div
              id="AOLMsgPart_1.2_05b1c8af-8e88-4b0d-869f-2caaa981ec41">
              <div text="#000000" bgcolor="#FFFFFF"
                class="aolReplacedBody">
                <div>Hi Gene,</div>
                <div>I also tried to import the csv data file and got
                  into difficulties.</div>
                <div>How did you import the ods file ? Can you send the
                  syntax ? <br>
                </div>
                <div>What is funny is that the country data set has no
                  case, i.e. country, names.</div>
                <div>Regards,</div>
                <div>ftr<br>
                </div>
                <br>
                <div class="aolmail_moz-cite-prefix">On 30/12/2017
                  01:00, someone wrote:<br>
                </div>
                <blockquote cite="about:blank"><font size="2"
                    face="arial" color="black">Hi all
                    <div><br>
                    </div>
                    <div>I'm trying to read in a data set, in csv. I
                      also have xls and ods versions, all here</div>
                    <div><a class="aolmail_moz-txt-link-freetext"
                        target="_blank" rel="noopener noreferrer"
removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="https://sites.google.com/site/gsocialchange/datasets"
                        moz-do-not-send="true">https://sites.google.com/site/gsocialchange/datasets</a><br>
                    </div>
                    <div><br>
                    </div>
                    <div>All the files I'm looking at are versions of
                      the pd_data_cia data set.</div>
                    <div><br>
                    </div>
                    <div>I -have- imported the ods version, but when I
                      try to import the csv version, I just get blank. I
                      go to file, import data, go to my directory, and
                      all the files are listed. I click on
                      pd_data_cia.cvs, and then on the upper left of the
                      screen, where it says select file to import, I
                      cannot select any of the options.</div>
                    <div><br>
                    </div>
                    <div>I am using pspp version 1.0.1-g818227,
                      downloaded a couple of days ago from here</div>
                    <div><a class="aolmail_moz-txt-link-freetext"
                        target="_blank" rel="noopener noreferrer"
removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="https://sourceforge.net/projects/pspp4windows/"
                        moz-do-not-send="true">https://sourceforge.net/projects/pspp4windows/</a><br>
                    </div>
                    <div>I'm on windows, 64 bit operating system, I
                      think windows 10.</div>
                    <div><br>
                    </div>
                    <div>I also tried using the command line, and, well,
                      not doing it right, perhaps someone can help?
                      These are the lines I tried</div>
                    <div><br>
                    </div>
                    <div>
                      <div>get data</div>
                      <div>  / type=txt </div>
                      <div>  /
                        file=’C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.csv’</div>
                      <div>  / arrangement=delimited</div>
                      <div>  / firstcase=2</div>
                      <div>  / delimiters=","</div>
                    </div>
                    <div><br>
                    </div>
                    <div>Thanks</div>
                    <div><br>
                    </div>
                    <div>Gene Shackman</div>
                    <div><br>
                    </div>
                  </font> <br>
                  <fieldset class="aolmail_mimeAttachmentHeader"></fieldset>
                  <br>
                  <pre>_______________________________________________
Pspp-users mailing list
<a class="aolmail_moz-txt-link-abbreviated" target="_blank" rel="noopener noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="mailto:Pspp-users@gnu.org" moz-do-not-send="true">Pspp-users@gnu.org</a>
<a class="aolmail_moz-txt-link-freetext" target="_blank" rel="noopener noreferrer" removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="https://lists.gnu.org/mailman/listinfo/pspp-users" moz-do-not-send="true">https://lists.gnu.org/mailman/listinfo/pspp-users</a>
</pre>
                </blockquote>
                <br>
              </div>
            </div>
            _______________________________________________<br>
            Pspp-users mailing list<br>
            Pspp-<a
removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="mailto:users@gnu.org"
              moz-do-not-send="true">users@gnu.org</a><br>
            <a
removedlink__09aa8067-9cb6-4366-9e43-5d33e50a3ed1__href="https://lists.gnu.org/mailman/listinfo/pspp-users"
              target="_blank" moz-do-not-send="true">https://lists.gnu.org/mailman/listinfo/pspp-users</a><br>
          </div>
        </div>
      </font>
    </blockquote>
    <br>
  </body>
</html>

--------------AFE054F5C5CA7EF6B38E463A--


From MAILER-DAEMON Sat Dec 30 19:35:56 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eVRbY-0003GQ-Tb
	for mharc-pspp-users@gnu.org; Sat, 30 Dec 2017 19:35:56 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:44811)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVRbV-0003C9-Iz
	for pspp-users@gnu.org; Sat, 30 Dec 2017 19:35:55 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVRbS-0005rN-CS
	for pspp-users@gnu.org; Sat, 30 Dec 2017 19:35:53 -0500
Received: from omr-a004e.mx.aol.com ([204.29.186.52]:41584)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <maffydoit@aol.com>) id 1eVRbS-0005mP-1k
	for pspp-users@gnu.org; Sat, 30 Dec 2017 19:35:50 -0500
Received: from mtaomg-aaf01.mx.aol.com (mtaomg-aaf01.mx.aol.com
	[172.26.127.99])
	by omr-a004e.mx.aol.com (Outbound Mail Relay) with ESMTP id
	A14CB380009E; Sat, 30 Dec 2017 19:35:45 -0500 (EST)
Received: from core-mbd03h.mail.aol.com (core-mbd03.mail.aol.com
	[172.27.110.13])
	by mtaomg-aaf01.mx.aol.com (OMAG/Core Interface) with ESMTP id
	60EB638000083; Sat, 30 Dec 2017 19:35:45 -0500 (EST)
Received: from 77.111.246.7 by webjasstg-vaa39.srv.aolmail.net (10.96.25.42)
	with HTTP (WebMailUI); Sat, 30 Dec 2017 19:35:45 -0500
Date: Sat, 30 Dec 2017 19:35:45 -0500
From: someone <maffydoit@aol.com>
To: public.ftr@free.fr, pspp-users@gnu.org
Message-Id: <160a9feefcf-c0b-1c8cd@webjasstg-vaa39.srv.aolmail.net>
In-Reply-To: <29b2965c-92e9-6294-f0eb-2a5c85a8dac3@free.fr>
Subject: reading csv data set
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_147302_1858722544.1514680545230"
X-MB-Message-Source: WebUI
X-MB-Message-Type: User
X-Mailer: JAS STD
X-Originating-IP: [77.111.246.7]
x-aol-global-disposition: G
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com;
	s=20150623; t=1514680545;
	bh=Dot/sW1UYuLDhsfypM8BOUvAvWlYCQyV2Jzc37Ld/jc=;
	h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type;
	b=hRljyWXVkRGkqi9XI+K81vcC3asfHRs5K2xuZ8OeS4Athbw93tEZBZqyC3frV1AEH
	rXkYIxLp3Xuf8QyNvINdhOriYxFc3+qHzvWzsK412rHgpIwutX+aNqtgSHc2diyG6S
	DLOcWNmiRfDETXxDdRQ6gJBJtB1SjBHODYMoiSro=
x-aol-sid: 3039ac1a7f635a4830e117bf
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.4.x-2.6.x [generic]
	[fuzzy]
X-Received-From: 204.29.186.52
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sun, 31 Dec 2017 00:35:55 -0000

------=_Part_147302_1858722544.1514680545230
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Thanks. I'm not really clear on what you mean.=20
"integrating several field delimiter into a single one"
"Only when you stop the last functionality the importation went as expected=
."


Can you please explain or give example?

Thanks for your help.


Gene




-----Original Message-----
From: ftr public <public.ftr@free.fr>
To: someone <maffydoit@aol.com>; pspp-users <pspp-users@gnu.org>
Sent: Sat, Dec 30, 2017 4:09 pm
Subject: Re: reading csv data set


   =20
Hi,
   =20
I imported the ods data file with the following syntax:
   =20
GET DATA /TYPE=3DODS
      /FILE=3D"(file path)\pd_data_cia.ods"
      /READNAMES=3DON.
   =20
    and it worked.
   =20
    I also imported the csv file into Libreoffice Calc to see the data.    =
When using the comma as a field delimiter I realised that the    function o=
f integrating several field delimiter into a single one    made that the im=
ported data and the column headers did not fit :    there were too few data=
 columns. Only when you stop the last    functionality the importation went=
 as expected.
    =20
    Thanks for the idea of a direct importation of ods files into PSPP    o=
f which I was unaware.
   =20
    - ftr
   =20
   =20
On 30/12/2017 18:49, someone wrote:
   =20
   =20
Hi       =20

       =20
       =20
Thanks for the response. I imported the ods file through          the gui i=
nterface. That is,=20
       =20
file
       =20
import data
       =20
went to my directory, clicked on the ods data set
       =20
next
       =20
got the screen importing spreadsheet data
       =20
next
       =20
apply
       =20

       =20
       =20
I did notice that, when I read the ods file, pspp, in the          output v=
iewer, showed this
       =20

       =20
       =20
get data
       =20
 /type=3Dods
       =20
 /file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"
           /sheet=3Dindex 1
       =20
 /readnames=3Don
       =20
 /cellrange=3Drange "a1:al236".
       =20

       =20
       =20

          So to try to read the csv file, I tried this
       =20

       =20
       =20
         =20
get data
         =20
  / type=3Dtxt=20
         =20
  /            file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data=
_cia.csv"
         =20
  / arrangement=3Ddelimited
         =20
  / firstcase=3D2
         =20
  / delimiters=3D",".
         =20

         =20
         =20
now, only one error:
         =20
.19: error: Syntax error at end of command: expecting            '/'.
         =20
          Does that help?
       =20

       =20
       =20
Thanks
       =20

       =20
       =20
Gene
       =20

         =20
         =20
         =20
-----Original            Message-----
            From: ftr public <public.ftr@free.fr>
            To: pspp-users <pspp-users@gnu.org>
            Sent: Sat, Dec 30, 2017 10:05 am
            Subject: Re: reading csv data set
           =20
           =20
             =20
               =20
Hi Gene,
               =20
I also tried to import the csv data file and got                  into diff=
iculties.
               =20
How did you import the ods file ? Can you send the                  syntax =
?=20
               =20
               =20
What is funny is that the country data set has no                  case, i.=
e. country, names.
               =20
Regards,
               =20
ftr
               =20
               =20
               =20
On 30/12/2017                  01:00, someone wrote:
               =20
               =20
Hi all                   =20

                   =20
                   =20
I'm trying to read in a data set, in csv. I                      also have =
xls and ods versions, all here
                   =20
https://sites.google.com/site/gsocialchange/datasets
                   =20
                   =20

                   =20
                   =20
All the files I'm looking at are versions of                      the pd_da=
ta_cia data set.
                   =20

                   =20
                   =20
I -have- imported the ods version, but when I                      try to i=
mport the csv version, I just get blank. I                      go to file,=
 import data, go to my directory, and                      all the files ar=
e listed. I click on                      pd_data_cia.cvs, and then on the =
upper left of the                      screen, where it says select file to=
 import, I                      cannot select any of the options.
                   =20

                   =20
                   =20
I am using pspp version 1.0.1-g818227,                      downloaded a co=
uple of days ago from here
                   =20
https://sourceforge.net/projects/pspp4windows/
                   =20
                   =20
I'm on windows, 64 bit operating system, I                      think windo=
ws 10.
                   =20

                   =20
                   =20
I also tried using the command line, and, well,                      not do=
ing it right, perhaps someone can help?                      These are the =
lines I tried
                   =20

                   =20
                   =20
                     =20
get data
                     =20
  / type=3Dtxt=20
                     =20
  /                        file=3D=E2=80=99C:\Users\Owner\Documents\icaap\d=
ata\testdata\PD_data_cia.csv=E2=80=99
                     =20
  / arrangement=3Ddelimited
                     =20
  / firstcase=3D2
                     =20
  / delimiters=3D","
                   =20
                   =20

                   =20
                   =20
Thanks
                   =20

                   =20
                   =20
Gene Shackman
                   =20

                   =20
                 =20



 =20


------=_Part_147302_1858722544.1514680545230
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<font color=3D'black' size=3D'2' face=3D'arial'>Thanks. I'm not really clea=
r on what you mean.&nbsp;
<div>"<span style=3D"font-family: arial, helvetica; font-size: 13.3333px;">=
integrating several field delimiter into a single one"</span></div>

<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
"</span></font><span style=3D"font-family: arial, helvetica; font-size: 13.=
3333px;">Only when you stop the last functionality the importation went as =
expected."</span></div>

<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
<br>
</span></font></div>

<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
Can you please explain or give example?<br>
</span></font><br>
Thanks for your help.</div>

<div><br>
</div>

<div>Gene</div>

<div><br>
</div>

<div><br>

<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original Message-----<br>
From: ftr public &lt;public.ftr@free.fr&gt;<br>
To: someone &lt;maffydoit@aol.com&gt;; pspp-users &lt;pspp-users@gnu.org&gt=
;<br>
Sent: Sat, Dec 30, 2017 4:09 pm<br>
Subject: Re: reading csv data set<br>
<br>


<div id=3D"AOLMsgPart_2_0e855415-1bd7-4a99-9f1f-51cf1639b592">

<div text=3D"#000000" bgcolor=3D"#FFFFFF" class=3D"aolReplacedBody">
   =20
<div>Hi,</div>

   =20
<div>I imported the ods data file with the following syntax:</div>

   =20
<div>GET DATA /TYPE=3DODS<br>

      /FILE=3D"(file path)\pd_data_cia.ods"<br>

      /READNAMES=3DON.<br>

    </div>

    and it worked.<br>

    <br>

    I also imported the csv file into Libreoffice Calc to see the data.
    When using the comma as a field delimiter I realised that the
    function of integrating several field delimiter into a single one
    made that the imported data and the column headers did not fit :
    there were too few data columns. Only when you stop the last
    functionality the importation went as expected.<br>

    &nbsp;<br>

    Thanks for the idea of a direct importation of ods files into PSPP
    of which I was unaware.<br>

    <br>

    - ftr<br>

    <br>

   =20
<div class=3D"aolmail_moz-cite-prefix">On 30/12/2017 18:49, someone wrote:<=
br>

    </div>

    <blockquote cite=3D"about:blank"><font size=3D"2" face=3D"arial" color=
=3D"black">Hi
       =20
<div><br>

        </div>

       =20
<div>Thanks for the response. I imported the ods file through
          the gui interface. That is,&nbsp;</div>

       =20
<div>file</div>

       =20
<div>import data</div>

       =20
<div>went to my directory, clicked on the ods data set</div>

       =20
<div>next</div>

       =20
<div>got the screen importing spreadsheet data</div>

       =20
<div>next</div>

       =20
<div>apply</div>

       =20
<div><br>

        </div>

       =20
<div>I did notice that, when I read the ods file, pspp, in the
          output viewer, showed this</div>

       =20
<div><br>

        </div>

       =20
<div>get data</div>

       =20
<div>&nbsp;/type=3Dods</div>

       =20
<div>&nbsp;/file=3D"<span style=3D"font-size: small;">C:\Users\Owner\Docume=
nts\icaap\data\testdata\PD_data_cia.ods"</span><br>

          &nbsp;/sheet=3Dindex 1</div>

       =20
<div>&nbsp;/readnames=3Don</div>

       =20
<div>&nbsp;/cellrange=3Drange "a1:al236".</div>

       =20
<div><br>

        </div>

       =20
<div><br>

          So to try to read the csv file, I tried this</div>

       =20
<div><br>

        </div>

       =20
<div>
         =20
<div>get data</div>

         =20
<div>&nbsp; / type=3Dtxt&nbsp;</div>

         =20
<div>&nbsp; /
            file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_ci=
a.csv"</div>

         =20
<div>&nbsp; / arrangement=3Ddelimited</div>

         =20
<div>&nbsp; / firstcase=3D2</div>

         =20
<div>&nbsp; / delimiters=3D",".</div>

         =20
<div><br>

          </div>

         =20
<div>now, only one error:</div>

         =20
<div>.19: error: Syntax error at end of command: expecting
            '/'.</div>

          <br>

          Does that help?</div>

       =20
<div><br>

        </div>

       =20
<div>Thanks</div>

       =20
<div><br>

        </div>

       =20
<div>Gene</div>

       =20
<div><br>

          <br>

          <br>

         =20
<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original
            Message-----<br>

            From: ftr public <a class=3D"aolmail_moz-txt-link-rfc2396E" tar=
get=3D"_blank" rel=3D"noopener noreferrer" href=3D"mailto:public.ftr@free.f=
r">&lt;public.ftr@free.fr&gt;</a><br>

            To: pspp-users <a class=3D"aolmail_moz-txt-link-rfc2396E" targe=
t=3D"_blank" rel=3D"noopener noreferrer" href=3D"mailto:pspp-users@gnu.org"=
>&lt;pspp-users@gnu.org&gt;</a><br>

            Sent: Sat, Dec 30, 2017 10:05 am<br>

            Subject: Re: reading csv data set<br>

            <br>

           =20
<div id=3D"aolmail_AOLMsgPart_1.2_05b1c8af-8e88-4b0d-869f-2caaa981ec41">
             =20
<div class=3D"aolmail_aolReplacedBody">
               =20
<div>Hi Gene,</div>

               =20
<div>I also tried to import the csv data file and got
                  into difficulties.</div>

               =20
<div>How did you import the ods file ? Can you send the
                  syntax ? <br>

                </div>

               =20
<div>What is funny is that the country data set has no
                  case, i.e. country, names.</div>

               =20
<div>Regards,</div>

               =20
<div>ftr<br>

                </div>

                <br>

               =20
<div class=3D"aolmail_aolmail_moz-cite-prefix">On 30/12/2017
                  01:00, someone wrote:<br>

                </div>

                <blockquote cite=3D"about:blank"><font size=3D"2" face=3D"a=
rial" color=3D"black">Hi all
                   =20
<div><br>

                    </div>

                   =20
<div>I'm trying to read in a data set, in csv. I
                      also have xls and ods versions, all here</div>

                   =20
<div><a class=3D"aolmail_aolmail_moz-txt-link-freetext" target=3D"_blank" r=
el=3D"noopener noreferrer">https://sites.google.com/site/gsocialchange/data=
sets</a><br>

                    </div>

                   =20
<div><br>

                    </div>

                   =20
<div>All the files I'm looking at are versions of
                      the pd_data_cia data set.</div>

                   =20
<div><br>

                    </div>

                   =20
<div>I -have- imported the ods version, but when I
                      try to import the csv version, I just get blank. I
                      go to file, import data, go to my directory, and
                      all the files are listed. I click on
                      pd_data_cia.cvs, and then on the upper left of the
                      screen, where it says select file to import, I
                      cannot select any of the options.</div>

                   =20
<div><br>

                    </div>

                   =20
<div>I am using pspp version&nbsp;1.0.1-g818227,
                      downloaded a couple of days ago from here</div>

                   =20
<div><a class=3D"aolmail_aolmail_moz-txt-link-freetext" target=3D"_blank" r=
el=3D"noopener noreferrer">https://sourceforge.net/projects/pspp4windows/</=
a><br>

                    </div>

                   =20
<div>I'm on windows, 64 bit operating system, I
                      think windows 10.</div>

                   =20
<div><br>

                    </div>

                   =20
<div>I also tried using the command line, and, well,
                      not doing it right, perhaps someone can help?
                      These are the lines I tried</div>

                   =20
<div><br>

                    </div>

                   =20
<div>
                     =20
<div>get data</div>

                     =20
<div>&nbsp; / type=3Dtxt&nbsp;</div>

                     =20
<div>&nbsp; /
                        file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data=
\testdata\PD_data_cia.csv=E2=80=99</div>

                     =20
<div>&nbsp; / arrangement=3Ddelimited</div>

                     =20
<div>&nbsp; / firstcase=3D2</div>

                     =20
<div>&nbsp; / delimiters=3D","</div>

                    </div>

                   =20
<div><br>

                    </div>

                   =20
<div>Thanks</div>

                   =20
<div><br>

                    </div>

                   =20
<div>Gene Shackman</div>

                   =20
<div><br>

                    </div>

                  </font></blockquote></div>
</div>
</div>
</div>
</font></blockquote><br>

 =20

</div>

</div>

</div>
</div>
</font>
------=_Part_147302_1858722544.1514680545230--


From MAILER-DAEMON Sun Dec 31 09:15:13 2017
Received: from list by lists.gnu.org with archive (Exim 4.71)
	id 1eVeOP-0008FD-4J
	for mharc-pspp-users@gnu.org; Sun, 31 Dec 2017 09:15:13 -0500
Received: from eggs.gnu.org ([2001:4830:134:3::10]:57802)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVeOL-0008Al-Fu
	for pspp-users@gnu.org; Sun, 31 Dec 2017 09:15:11 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <maffydoit@aol.com>) id 1eVeOI-00053r-2v
	for pspp-users@gnu.org; Sun, 31 Dec 2017 09:15:09 -0500
Received: from omr-a010e.mx.aol.com ([204.29.186.54]:53686)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <maffydoit@aol.com>) id 1eVeOH-00053b-Ob
	for pspp-users@gnu.org; Sun, 31 Dec 2017 09:15:06 -0500
Received: from mtaomg-aaf02.mx.aol.com (mtaomg-aaf02.mx.aol.com
	[172.26.127.100])
	by omr-a010e.mx.aol.com (Outbound Mail Relay) with ESMTP id
	140133800099
	for <pspp-users@gnu.org>; Sun, 31 Dec 2017 09:15:05 -0500 (EST)
Received: from core-mbd03h.mail.aol.com (core-mbd03.mail.aol.com
	[172.27.110.13])
	by mtaomg-aaf02.mx.aol.com (OMAG/Core Interface) with ESMTP id
	5089A38000082
	for <pspp-users@gnu.org>; Sun, 31 Dec 2017 09:15:04 -0500 (EST)
Received: from 77.111.246.13 by webjasstg-vaa01.srv.aolmail.net (10.96.25.4)
	with HTTP (WebMailUI); Sun, 31 Dec 2017 09:15:03 -0500
Date: Sun, 31 Dec 2017 09:15:03 -0500
From: someone <maffydoit@aol.com>
To: pspp-users@gnu.org
Message-Id: <160aced0773-c09-1de1b@webjasstg-vaa01.srv.aolmail.net>
In-Reply-To: <160a9feefcf-c0b-1c8cd@webjasstg-vaa39.srv.aolmail.net>
Subject: reading csv data set
MIME-Version: 1.0
Content-Type: multipart/alternative; 
	boundary="----=_Part_153979_1239843224.1514729703283"
X-MB-Message-Source: WebUI
X-MB-Message-Type: User
X-Mailer: JAS STD
X-Originating-IP: [77.111.246.13]
x-aol-global-disposition: G
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mx.aol.com;
	s=20150623; t=1514729705;
	bh=32RB6O4n0FWMFKJ1TNQcpxs5Gs5gPAoT6LNejOqdQhA=;
	h=From:To:Subject:Message-Id:Date:MIME-Version:Content-Type;
	b=IkBLcyJEBZD1ph7Vtm77ekc5pcIWzvRt5MwDmCakXi6fWTrCYqbNp4/GBJJByFu7K
	vsSe5B4t4xlUbt6XmfHNIJ7tVInNyOQou022Wzlh4M0LKE413uGHhAKNuyJ28WEUcs
	BajoWCp6QR3mWDDQ+PHwty90SWqZmeLJiGhMNlVs=
x-aol-sid: 3039ac1a7f645a48f0e829cd
X-detected-operating-system: by eggs.gnu.org: GNU/Linux 2.4.x-2.6.x [generic]
	[fuzzy]
X-Received-From: 204.29.186.54
X-BeenThere: pspp-users@gnu.org
X-Mailman-Version: 2.1.21
Precedence: list
List-Id: PSPP user discussion <pspp-users.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/pspp-users/>
List-Post: <mailto:pspp-users@gnu.org>
List-Help: <mailto:pspp-users-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/pspp-users>,
	<mailto:pspp-users-request@gnu.org?subject=subscribe>
X-List-Received-Date: Sun, 31 Dec 2017 14:15:11 -0000

------=_Part_153979_1239843224.1514729703283
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Could I ask what syntax you used to read my csv data set?


Thanks again for all your feedback


Gene




-----Original Message-----
From: someone <maffydoit@aol.com>
To: public.ftr <public.ftr@free.fr>; pspp-users <pspp-users@gnu.org>
Sent: Sat, Dec 30, 2017 7:35 pm
Subject: reading csv data set


Thanks. I'm not really clear on what you mean.=20
"integrating several field delimiter into a single one"
"Only when you stop the last functionality the importation went as expected=
."


Can you please explain or give example?

Thanks for your help.


Gene




-----Original Message-----
From: ftr public <public.ftr@free.fr>
To: someone <maffydoit@aol.com>; pspp-users <pspp-users@gnu.org>
Sent: Sat, Dec 30, 2017 4:09 pm
Subject: Re: reading csv data set


   =20
Hi,
   =20
I imported the ods data file with the following syntax:
   =20
GET DATA /TYPE=3DODS
      /FILE=3D"(file path)\pd_data_cia.ods"
      /READNAMES=3DON.
   =20
    and it worked.
   =20
    I also imported the csv file into Libreoffice Calc to see the data.    =
When using the comma as a field delimiter I realised that the    function o=
f integrating several field delimiter into a single one    made that the im=
ported data and the column headers did not fit :    there were too few data=
 columns. Only when you stop the last    functionality the importation went=
 as expected.
    =20
    Thanks for the idea of a direct importation of ods files into PSPP    o=
f which I was unaware.
   =20
    - ftr
   =20
   =20
On 30/12/2017 18:49, someone wrote:
   =20
   =20
Hi       =20

       =20
       =20
Thanks for the response. I imported the ods file through          the gui i=
nterface. That is,=20
       =20
file
       =20
import data
       =20
went to my directory, clicked on the ods data set
       =20
next
       =20
got the screen importing spreadsheet data
       =20
next
       =20
apply
       =20

       =20
       =20
I did notice that, when I read the ods file, pspp, in the          output v=
iewer, showed this
       =20

       =20
       =20
get data
       =20
 /type=3Dods
       =20
 /file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_cia.ods"
           /sheet=3Dindex 1
       =20
 /readnames=3Don
       =20
 /cellrange=3Drange "a1:al236".
       =20

       =20
       =20

          So to try to read the csv file, I tried this
       =20

       =20
       =20
         =20
get data
         =20
  / type=3Dtxt=20
         =20
  /            file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data=
_cia.csv"
         =20
  / arrangement=3Ddelimited
         =20
  / firstcase=3D2
         =20
  / delimiters=3D",".
         =20

         =20
         =20
now, only one error:
         =20
.19: error: Syntax error at end of command: expecting            '/'.
         =20
          Does that help?
       =20

       =20
       =20
Thanks
       =20

       =20
       =20
Gene
       =20

         =20
         =20
         =20
-----Original            Message-----
            From: ftr public <public.ftr@free.fr>
            To: pspp-users <pspp-users@gnu.org>
            Sent: Sat, Dec 30, 2017 10:05 am
            Subject: Re: reading csv data set
           =20
           =20
             =20
               =20
Hi Gene,
               =20
I also tried to import the csv data file and got                  into diff=
iculties.
               =20
How did you import the ods file ? Can you send the                  syntax =
?=20
               =20
               =20
What is funny is that the country data set has no                  case, i.=
e. country, names.
               =20
Regards,
               =20
ftr
               =20
               =20
               =20
On 30/12/2017                  01:00, someone wrote:
               =20
               =20
Hi all                   =20

                   =20
                   =20
I'm trying to read in a data set, in csv. I                      also have =
xls and ods versions, all here
                   =20
https://sites.google.com/site/gsocialchange/datasets
                   =20
                   =20

                   =20
                   =20
All the files I'm looking at are versions of                      the pd_da=
ta_cia data set.
                   =20

                   =20
                   =20
I -have- imported the ods version, but when I                      try to i=
mport the csv version, I just get blank. I                      go to file,=
 import data, go to my directory, and                      all the files ar=
e listed. I click on                      pd_data_cia.cvs, and then on the =
upper left of the                      screen, where it says select file to=
 import, I                      cannot select any of the options.
                   =20

                   =20
                   =20
I am using pspp version 1.0.1-g818227,                      downloaded a co=
uple of days ago from here
                   =20
https://sourceforge.net/projects/pspp4windows/
                   =20
                   =20
I'm on windows, 64 bit operating system, I                      think windo=
ws 10.
                   =20

                   =20
                   =20
I also tried using the command line, and, well,                      not do=
ing it right, perhaps someone can help?                      These are the =
lines I tried
                   =20

                   =20
                   =20
                     =20
get data
                     =20
  / type=3Dtxt=20
                     =20
  /                        file=3D=E2=80=99C:\Users\Owner\Documents\icaap\d=
ata\testdata\PD_data_cia.csv=E2=80=99
                     =20
  / arrangement=3Ddelimited
                     =20
  / firstcase=3D2
                     =20
  / delimiters=3D","
                   =20
                   =20

                   =20
                   =20
Thanks
                   =20

                   =20
                   =20
Gene Shackman
                   =20

                   =20
                 =20



 =20




------=_Part_153979_1239843224.1514729703283
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable

<font color=3D'black' size=3D'2' face=3D'arial'>Could I ask what syntax you=
 used to read my csv data set?
<div><br>
</div>

<div>Thanks again for all your feedback</div>

<div><br>
</div>

<div>Gene</div>

<div><br>
<br>
<br>

<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original Message-----<br>
From: someone &lt;maffydoit@aol.com&gt;<br>
To: public.ftr &lt;public.ftr@free.fr&gt;; pspp-users &lt;pspp-users@gnu.or=
g&gt;<br>
Sent: Sat, Dec 30, 2017 7:35 pm<br>
Subject: reading csv data set<br>
<br>


<div id=3D"AOLMsgPart_2_3e6b14b8-a00d-4399-82de-6ceac45d3735">

<div class=3D"aolReplacedBody"><font color=3D"black" size=3D"2" face=3D"ari=
al">Thanks. I'm not really clear on what you mean.&nbsp;

<div>"<span style=3D"font-family: arial, helvetica; font-size: 13.3333px;">=
integrating several field delimiter into a single one"</span></div>



<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
"</span></font><span style=3D"font-family: arial, helvetica; font-size: 13.=
3333px;">Only when you stop the last functionality the importation went as =
expected."</span></div>



<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
<br>

</span></font></div>



<div><font face=3D"arial, helvetica"><span style=3D"font-size: 13.3333px;">=
Can you please explain or give example?<br>

</span></font><br>

Thanks for your help.</div>



<div><br>

</div>



<div>Gene</div>



<div><br>

</div>



<div><br>



<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original Message-----<br>

From: ftr public &lt;<a href=3D"mailto:public.ftr@free.fr">public.ftr@free.=
fr</a>&gt;<br>

To: someone &lt;<a href=3D"mailto:maffydoit@aol.com">maffydoit@aol.com</a>&=
gt;; pspp-users &lt;pspp-<a href=3D"mailto:users@gnu.org">users@gnu.org</a>=
&gt;<br>

Sent: Sat, Dec 30, 2017 4:09 pm<br>

Subject: Re: reading csv data set<br>

<br>




<div id=3D"aolmail_AOLMsgPart_2_0e855415-1bd7-4a99-9f1f-51cf1639b592">


<div class=3D"aolmail_aolReplacedBody">
   =20

<div>Hi,</div>


   =20

<div>I imported the ods data file with the following syntax:</div>


   =20

<div>GET DATA /TYPE=3DODS<br>


      /FILE=3D"(file path)\pd_data_cia.ods"<br>


      /READNAMES=3DON.<br>


    </div>


    and it worked.<br>


    <br>


    I also imported the csv file into Libreoffice Calc to see the data.
    When using the comma as a field delimiter I realised that the
    function of integrating several field delimiter into a single one
    made that the imported data and the column headers did not fit :
    there were too few data columns. Only when you stop the last
    functionality the importation went as expected.<br>


    &nbsp;<br>


    Thanks for the idea of a direct importation of ods files into PSPP
    of which I was unaware.<br>


    <br>


    - ftr<br>


    <br>


   =20

<div class=3D"aolmail_aolmail_moz-cite-prefix">On 30/12/2017 18:49, someone=
 wrote:<br>


    </div>


    <blockquote cite=3D"about:blank"><font size=3D"2" face=3D"arial" color=
=3D"black">Hi
       =20

<div><br>


        </div>


       =20

<div>Thanks for the response. I imported the ods file through
          the gui interface. That is,&nbsp;</div>


       =20

<div>file</div>


       =20

<div>import data</div>


       =20

<div>went to my directory, clicked on the ods data set</div>


       =20

<div>next</div>


       =20

<div>got the screen importing spreadsheet data</div>


       =20

<div>next</div>


       =20

<div>apply</div>


       =20

<div><br>


        </div>


       =20

<div>I did notice that, when I read the ods file, pspp, in the
          output viewer, showed this</div>


       =20

<div><br>


        </div>


       =20

<div>get data</div>


       =20

<div>&nbsp;/type=3Dods</div>


       =20

<div>&nbsp;/file=3D"<span style=3D"font-size: small;">C:\Users\Owner\Docume=
nts\icaap\data\testdata\PD_data_cia.ods"</span><br>


          &nbsp;/sheet=3Dindex 1</div>


       =20

<div>&nbsp;/readnames=3Don</div>


       =20

<div>&nbsp;/cellrange=3Drange "a1:al236".</div>


       =20

<div><br>


        </div>


       =20

<div><br>


          So to try to read the csv file, I tried this</div>


       =20

<div><br>


        </div>


       =20

<div>
         =20

<div>get data</div>


         =20

<div>&nbsp; / type=3Dtxt&nbsp;</div>


         =20

<div>&nbsp; /
            file=3D"C:\Users\Owner\Documents\icaap\data\testdata\PD_data_ci=
a.csv"</div>


         =20

<div>&nbsp; / arrangement=3Ddelimited</div>


         =20

<div>&nbsp; / firstcase=3D2</div>


         =20

<div>&nbsp; / delimiters=3D",".</div>


         =20

<div><br>


          </div>


         =20

<div>now, only one error:</div>


         =20

<div>.19: error: Syntax error at end of command: expecting
            '/'.</div>


          <br>


          Does that help?</div>


       =20

<div><br>


        </div>


       =20

<div>Thanks</div>


       =20

<div><br>


        </div>


       =20

<div>Gene</div>


       =20

<div><br>


          <br>


          <br>


         =20

<div style=3D"font-family:arial,helvetica;font-size:10pt;color:black">-----=
Original
            Message-----<br>


            From: ftr public <a class=3D"aolmail_aolmail_moz-txt-link-rfc23=
96E" target=3D"_blank" rel=3D"noopener noreferrer" href=3D"mailto:public.ft=
r@free.fr">&lt;public.ftr@free.fr&gt;</a><br>


            To: pspp-users <a class=3D"aolmail_aolmail_moz-txt-link-rfc2396=
E" target=3D"_blank" rel=3D"noopener noreferrer" href=3D"mailto:pspp-users@=
gnu.org">&lt;pspp-users@gnu.org&gt;</a><br>


            Sent: Sat, Dec 30, 2017 10:05 am<br>


            Subject: Re: reading csv data set<br>


            <br>


           =20

<div id=3D"aolmail_aolmail_AOLMsgPart_1.2_05b1c8af-8e88-4b0d-869f-2caaa981e=
c41">
             =20

<div class=3D"aolmail_aolmail_aolReplacedBody">
               =20

<div>Hi Gene,</div>


               =20

<div>I also tried to import the csv data file and got
                  into difficulties.</div>


               =20

<div>How did you import the ods file ? Can you send the
                  syntax ? <br>


                </div>


               =20

<div>What is funny is that the country data set has no
                  case, i.e. country, names.</div>


               =20

<div>Regards,</div>


               =20

<div>ftr<br>


                </div>


                <br>


               =20

<div class=3D"aolmail_aolmail_aolmail_moz-cite-prefix">On 30/12/2017
                  01:00, someone wrote:<br>


                </div>


                <blockquote cite=3D"about:blank"><font size=3D"2" face=3D"a=
rial" color=3D"black">Hi all
                   =20

<div><br>


                    </div>


                   =20

<div>I'm trying to read in a data set, in csv. I
                      also have xls and ods versions, all here</div>


                   =20

<div><a class=3D"aolmail_aolmail_aolmail_moz-txt-link-freetext" target=3D"_=
blank" rel=3D"noopener noreferrer">https://sites.google.com/site/gsocialcha=
nge/datasets</a><br>


                    </div>


                   =20

<div><br>


                    </div>


                   =20

<div>All the files I'm looking at are versions of
                      the pd_data_cia data set.</div>


                   =20

<div><br>


                    </div>


                   =20

<div>I -have- imported the ods version, but when I
                      try to import the csv version, I just get blank. I
                      go to file, import data, go to my directory, and
                      all the files are listed. I click on
                      pd_data_cia.cvs, and then on the upper left of the
                      screen, where it says select file to import, I
                      cannot select any of the options.</div>


                   =20

<div><br>


                    </div>


                   =20

<div>I am using pspp version&nbsp;1.0.1-g818227,
                      downloaded a couple of days ago from here</div>


                   =20

<div><a class=3D"aolmail_aolmail_aolmail_moz-txt-link-freetext" target=3D"_=
blank" rel=3D"noopener noreferrer">https://sourceforge.net/projects/pspp4wi=
ndows/</a><br>


                    </div>


                   =20

<div>I'm on windows, 64 bit operating system, I
                      think windows 10.</div>


                   =20

<div><br>


                    </div>


                   =20

<div>I also tried using the command line, and, well,
                      not doing it right, perhaps someone can help?
                      These are the lines I tried</div>


                   =20

<div><br>


                    </div>


                   =20

<div>
                     =20

<div>get data</div>


                     =20

<div>&nbsp; / type=3Dtxt&nbsp;</div>


                     =20

<div>&nbsp; /
                        file=3D=E2=80=99C:\Users\Owner\Documents\icaap\data=
\testdata\PD_data_cia.csv=E2=80=99</div>


                     =20

<div>&nbsp; / arrangement=3Ddelimited</div>


                     =20

<div>&nbsp; / firstcase=3D2</div>


                     =20

<div>&nbsp; / delimiters=3D","</div>


                    </div>


                   =20

<div><br>


                    </div>


                   =20

<div>Thanks</div>


                   =20

<div><br>


                    </div>


                   =20

<div>Gene Shackman</div>


                   =20

<div><br>


                    </div>


                  </font></blockquote></div>

</div>

</div>

</div>

</font></blockquote><br>


 =20

</div>


</div>


</div>

</div>

</font></div>

</div>

</div>
</div>
</font>
------=_Part_153979_1239843224.1514729703283--


