Re: Import SPSS file fails because of datetime width

[John Darrington]

On Fri, Aug 06, 2010 at 05:02:39PM +0200, Andreas Lappe wrote:
     On  5.08.10, John Darrington wrote:
     > If you change DATETIME to DATETIME20 and put your date in
     > quotes, then this should work.
     > If your unmodified file works on SPSS, then this should be considered a 
bug
     > and reported like any other.
     > J'
     
     It was quite an odyssey but I got my hands on SPSS 17 and tried to
     import that set: Works without any questions. So I'd file it as a bug
     ASAP. 
     
     But as I have to make my analysis for my thesis, is there a quick fix I
     can do to make it work in PSPP? I don't have the time to wait for an
     update, I guess.
     
     Changing DATETIME to DATETIME20 I get errors about values not being
     numbers, so that's your quoting. Do I have to quote everything that's
     not a number? Or just every field?
     
     Thank you for your help
     Andy
     

I think the problem is the space in the date/time.  If the date/time is supposed
to be parsed as one field then you'll have to quote it.

J'

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

signature.asc
Description: Digital signature