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 <j...@darrington.wattle.id.au> 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 > <mic...@michelboaventura.com> 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----- > > _______________________________________________ Pspp-users mailing list Pspp-users@gnu.org http://lists.gnu.org/mailman/listinfo/pspp-users
