Re: difficulty converting spreadsheet convertion

[Tom Chung]

I've just converted the file now!  I appreciate your help, and am glad
to see one more demonstration of good human beihavior!

Tom

On Tue, Jun 15, 2010 at 10:30 AM, John Darrington
<address@hidden> wrote:
> I think what Michel meant was for you to post the comma seperated file,
> (containing fake data f necessary) rather than the .xls file.  Not everyone
> uses Windows so it's best to avoid those formats if you can.
>
>
> Anyway I took your .xls file and converted it to .csv using OpenOffice.org
> and then imported it into psppire using the "File->Import Delimited Text Data"
> menuitem.  It seemed to work fine for me.  The only problem was that one cell
> in your file contains "xy" instead of a number.  Pspp correctly flags a 
> warning
> about this and inserts a "system missing" value for that cell.
>
> Below, is the syntax which Psppire generates for me.  You might find it 
> useful.
>
> GET DATA
>  /TYPE=TXT
>  /FILE="/home/john/small-sample.csv"
>  /IMPORTCASES=ALL
>  /ARRANGEMENT=DELIMITED
>  /DELCASE=LINE
>  /FIRSTCASE=2
>  /DELIMITERS=","
>  /QUALIFIER='"'
>  /ESCAPE
>  /VARIABLES=
>    VAR001 F3.0
>    VAR002 F2.0
>    VAR003 F1.0
>    VAR004 F2.0
>    VAR005 F2.0
>    VAR006 F1.0
>    VAR007 F3.0
>    VAR008 F1.0
>    VAR009 F1.0
>    VAR010 F1.0
>    VAR011 F1.0
>    VAR012 F1.0
>    VAR013 F1.0
>    VAR014 F1.0
>    VAR015 F1.0
>    VAR016 F1.0
>    VAR017 F1.0
>    VAR018 F1.0
>    VAR019 F1.0
>    VAR020 F1.0
>    VAR021 F1.0
>    VAR022 F1.0
>    VAR023 F1.0
>    VAR024 F1.0
>    VAR025 F1.0
>    VAR026 F1.0
>    VAR027 F1.0
>    VAR028 F1.0
>    VAR029 F1.0
>    VAR030 F1.0
>    VAR031 F1.0
>    VAR032 F1.0
>    VAR033 F1.0
>    VAR034 F1.0
>    VAR035 F1.0
>    VAR036 F1.0
>    VAR037 F1.0
>    VAR038 F1.0
>    VAR039 F1.0
>    VAR040 F1.0
>    VAR041 F1.0
>    VAR042 F2.0
>    VAR043 F1.0
>    VAR044 F1.0
>    VAR045 F1.0
>    VAR046 F1.0
>    VAR047 F1.0
>    VAR048 F1.0
>    VAR049 F1.0
>    VAR050 F1.0
>    VAR051 F1.0
>    VAR052 F1.0
>    VAR053 F1.0
>    VAR054 F1.0
>    VAR055 F1.0
>    VAR056 F1.0
>    VAR057 F1.0
>    VAR058 F1.0
>    VAR059 F1.0
>    VAR060 F1.0
>    VAR061 F1.0
>    VAR062 F1.0
>    VAR063 F1.0
>    VAR064 F1.0
>    VAR065 F1.0
>    VAR066 F1.0
>    VAR067 F1.0
>    VAR068 F1.0
>    VAR069 F1.0
>    VAR070 F1.0
>    VAR071 F1.0
>    VAR072 F1.0
>    VAR073 F1.0
>    VAR074 F1.0
>    VAR075 F1.0
>    VAR076 F1.0
>    VAR077 F1.0
>    VAR078 F1.0
>    VAR079 F2.0
>    VAR080 F1.0
>    VAR081 F1.0
>    VAR082 F2.0
>    VAR083 F1.0
>    VAR084 F1.0
>    VAR085 F1.0
>    VAR086 F1.0
>    VAR087 F1.0
>    VAR088 F1.0
>    VAR089 F1.0
>    VAR090 F1.0
>    VAR091 F1.0
>    VAR092 F1.0
>    VAR093 F1.0
>    VAR094 F1.0
>    VAR095 F1.0
>    VAR096 F1.0
>    VAR097 F1.0
>    VAR098 F1.0
>    VAR099 F1.0
>    VAR100 F1.0
>    VAR101 F1.0
>    VAR102 F1.0.
>
>
> On Mon, Jun 14, 2010 at 05:09:31PM -0400, Tom Chung wrote:
>     Thanks, Michel.
>
>     Data entry is not yet finished.  Due to privicy concern, it is not
>     appropriate for me to email it out.  Your advice about the procedures
>     to convert the spreadsheet would be good enough and much appreciated.
>
>     Tom
>
>     On Mon, Jun 14, 2010 at 5:02 PM, Michel Boaventura
>     <address@hidden> wrote:
>     > Hello Tom,
>     >
>     > Could you please send the delimited file that you've created? I think 
> would
>     > be easier
>     > to the list to help you out with this.
>     >
>     > Regards,
>     >
>     > Michel
>     >
>
> --
> PGP Public key ID: 1024D/2DE827B3
> fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
> See http://pgp.mit.edu or any PGP keyserver for public key.
>
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iD8DBQFMF46FimdxnC3oJ7MRApCTAJ9WHctcNrjqvs8GPgHTV+pSllW9sACfbrxO
> h9pK7kpqAnsq+I7qUvxZohE=
> =Gpmy
> -----END PGP SIGNATURE-----
>
>